Perspective Table: How to display value in dropdown?

I am wondering if there is a way to display a dataset value in as the dropdown value in the perspective table?

I have the table setup to write the “WAREHOUSE_FUNCTIONAL_AREA” value to a database when it is modified, but I am not able to get the current database value to display in the dropdown box when the table is relaunched. Any help would be appreciated. The dropdown is a view that is tied into the table column.

From my limited experience, your dropdown should be in a view that is used in the table. The view should take two parameters:

  1. The dataset or JSON object containing the options.
  2. The value property of the option to be selected.

You would then bind the dropdown properties to the view parameters.