AnsweredAssumed Answered

Filtering Drop-Down List Values

Question asked by CraigRozelle on Mar 10, 2012
Latest reply on Mar 10, 2012 by philmodjunk


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?