AnsweredAssumed Answered

Filter a table thru relationship

Question asked by RonaldCarr on Mar 5, 2013
Latest reply on Mar 11, 2013 by philmodjunk

Title

Filter a table thru relationship

Post

     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?

     Thanks!

Outcomes