Unanswered: difficulty setting up query to show employee/client relationship??
Guys, I'm having a bit of difficulty setting up a database for a friend's business.
What i need to do is be able to run a query that will tell me what clients an employee is working on at any given time. The only problem I'm really stuck on is that I need to state the Telemarketer, Sales Person, and Demonstrator for each client and these can over lap (with one employee doing both). I'm having trouble with the query - as when i put in as a field for the query i put both/all telemarketer, sales person and demonstrator, it only returns results where the employee in question is working on all three.
I need to be able to see - regardless of what they are doing, which clients they are working on, probably be good to see what they actually are doing to.