AnsweredAssumed Answered

Help with Relationships

Question asked by john.s on Dec 2, 2013
Latest reply on Dec 2, 2013 by john.s

Title

Help with Relationships

Post

I have a customer table that contains a customer type field (ie school, corporation, person) when creating a job I want to only return a list of customers with a type that is appropriate for that type of job, i.e. if it is a portrait job I want to bring up a pop up with only customer type of “person” for Yearbook jobs only “Schools” etc.  I have the Schools portion working but can’t figure out why the other job types always bring up the entire customer table.  Here’s the relationship diagram I know something is wrong but can’t figure out what.

Screen_Shot_2013-12-02_at_4.27.25_PM.png

Outcomes