I can’t find a way to prefill a dropdown control with the unique list of items (external collection) and also have it set the default value to the currently selected item from the prior screen’s list so that a user can change the value through the use of the dropdown list and then do an update back to the external collection.
I have a dance table as an external collection. The dance table has two of its integer columns that reference separate tables (i.e dance_style, dance_size) that have a normalized list of styles and sizes
- Large Group
My goal is to have an update screen for a dance. From a dance list screen, clicking on a dance item will take the user to an update screen for the selected dance. The update screen will have the fields prefilled based on the values of the selected dance. Two of the fields are dropdowns (dance style, dance size).
The dropdowns need to have the unique list from the dance_style and dance_size tables. Also, the default value for the dropdowns should be based on the integer in the dance table columns for dance_style and dance_size (the name will be shown, not the dance_style and dance_size integer key values)
Currently, this won’t work because the source you choose for a dropdown is also what you have to use to set the Default value.
If you could choose the source for a dropdown as the external collection dance_style and dance_size and then use the Current Dance data to set the Default Value I think all would be well.
Please let me know if my interpretation of the problem I am encountering is accurate. If so, and there is no semi-clean way to work around it, I will open a feature ticket for it.