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?