Help with Relationships
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.