AnsweredAssumed Answered

This must be simple

Question asked by MarkPage_1 on Jan 12, 2016
Latest reply on Jan 13, 2016 by beverly

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...

 

Cheers

 

Mark

Outcomes