AnsweredAssumed Answered

Conditional Value lists

Question asked by pdoak_1 on Aug 11, 2011
Latest reply on Aug 11, 2011 by philmodjunk

Title

Conditional Value lists

Post

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:

  • id
  • allocId
  • ActiveFlag
  • Name
  • Currency
  • Type
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:
 
  • id
  • Type
  • Currency
Is there a way to do this as the value list only gives one the option to sort based upon two fields?
 

Outcomes