ok, so I created a new data type called Help_Category with all the values and I load then into the drop down. When the user selected the value from the drop down it saves the unique id of that drop down field in the Post datatype. However, the issue I am having is for an existing record when I display the screen, I want that to be shown as the default value in the drop down.
I just can’t seem to get the right expression written in the Default value field in the drop down element.
Firstly (assuming I’ve understood your post correctly), why are you saving the Unique ID instead of the datatype object itself? (that will make it much simpler)…
Then all you’d need to do is set the default value to be the Post’s Help-Category
But, as you’re saving the unique ID as a text (at least that’s what I understood from your post), you’ll need to do a database search to find the Help_Category in question…
So, in the default value do a search for Help-Categories, with a constraint of Unique ID = the Post’s Help-Category, then select the first Item from the returned list.
Hi Adam, I tried to save the datatype object itself (as you suggested as the preferred method) but it is requiring the value of the set. (see below). So when i picked value it saves the unique id.