AnsweredAssumed Answered

How to display selected records in a dropdown list

Question asked by LaurenceHarrould on Feb 18, 2013
Latest reply on Feb 19, 2013 by philmodjunk


How to display selected records in a dropdown list


     I have a number of tables used as the contents for dropdown lists. The administrator can mark certain items as being obsolete and these shouldn't appear in the DDL. I haven't been able to get this to work.

     Each table has a field "_constant" (Type Numeric, value 1) and another "Obsolete". I've tried linking to the System table using [table._constant = System._constant AND table.obsolete <> system._constant] but this only works when the record already has a value, not when creating a new record.

     For example, I have a table of Members and they can be members of different Groups. So, I have Group as a DDL to select from, which populates the GroupID field in the Member table. If a group is no longer active the Administrator can mark it as Obsolete and naturally I don't want it to appear in the DDL anymore.

     How do I do it?