1 Reply Latest reply on Mar 10, 2012 10:23 PM by philmodjunk

    Filtering Drop-Down List Values



      Filtering Drop-Down List Values


      I have a table named "transaction_journal" that contains a field named "sales_representative". This field is populated by selecting a name from a drop-down list. The drop-down list is from a related table named "associates" which contains three fields: "associate_id", "full_name", and "active". The drop-down values are derived from the "full_name" field.

      I would like the drop-down list to be filtered for "full_name" by records where the "active" field is "yes". How do I best accomplish this?