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?