I've setup a dropdown which references a separate table in my DB which holds the following data:
- LegendCode - this holds a 3 digit code stored as a text in my db.
- LegendDesc - this holds a more user friendly concatenation of the 3 digit code and a description of what the code represents, again stored as text in my db.
- Order - just a column to allow me to manually order my values in the dropdown, stored as integers in my db.
Now in my dropdown control the datacard.Items value field is set to LegendDesc, nice for users. When an option is selected and the form updated, the value passed to my form results DB table is the LegendCode value.
The problem I have is when I go to edit the form, I have the values load fine except the dropdown which defaults to the first value of the LegendDesc. Dropdown values are fine in other sheets with hand entered values, but this one doesn't seem to play nice. I've tried this formula in the Default:
- LookUp('[Access].[type_strata]',ThisItem.StrataLegend=LegendCode,LegendDesc)
And also tried a slight variation:
- LookUp('[Access].[type_strata]',LegendCode=ThisItem.StrataLegend,LegendDesc)
Both make no difference. Has anyone else experienced this and found a way round it?
