I have a table with two related tables. One is for Contact_ID and the other is Employer_ID.
Each has a field with either active or inactive in it.
In my main table I want to select (using a drop down box) from the contacts who are only 'Active'.
I'm a bit baffled by this seemingly simple desire. Can anyone help, or point me in the right direction?
I feel like such a numpty...