Hello,
I have a form that pulls in data from a reference table. When you open the drop down to select an item, I want to sort the values in the drop down menu.
Any ideas?
Thank you!!
jennie
Solved! Go to Solution.
I believe you could try in the valid_if of the dropdown column in the child table
ORDERBY(Parent Table [Parent Key], [Parent Label])
I believe you could try in the valid_if of the dropdown column in the child table
ORDERBY(Parent Table [Parent Key], [Parent Label])
That worked! Thank you!!
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |