Conditional Value lists
I would like to sort a conditional value list in a particular order but I am struggling to get find out how to do it. I have a table with four fields:
I have set up a table relationship which selects records in this table where the activeFlag ="Active" and the conditional value list works in that it shows all records where the activeFlag field equals "active". However, I would like to sort the value list like:
Is there a way to do this as the value list only gives one the option to sort based upon two fields?