Filter a table thru relationship
I have a table of Contacts.
These contacts may be Jobseekers, Employers, Donors or any combination of thoses.
I also have a related ContactType table with at least one record per contact, identifying which Type(s) each contact is.
I tried to set up a TOG with Employer_ContactType = Employer and Employer_ContactID = Employer_ContactType ContactID
I assumed that if I used Employer_Contact from the TOG it would only have Contacts who were employers, but that is not working.
All data in the tables and the calculation (cEmployer) is correct...am Ioff base here?
Better way to do it?