Extracting Job Titles from Fields
I have 2 tables, one is Staff and one is Photographer Jobs and they both have the following fields:
Staff: Name | Job Title
Photographer Jobs: Booking | Photographer
In the Staff table there are multiple staff but only SOME of them are photographers and they have that Job Title assigned to them.
In the Photographers Jobs table ONLY photographers can be assigned jobs, so when you select the Photographer field the drop down should only list people who have the Job Title of 'Photographer'. How do I make the value list so it ignores other job titles?
I hope this is clear enough and thank you in advance for your help - it is REALLY appreciated.