3 Replies Latest reply on Feb 19, 2013 7:31 AM by philmodjunk

    How to display selected records in a dropdown list

    LaurenceHarrould

      Title

      How to display selected records in a dropdown list

      Post

           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?

           Thanks

           L