AnsweredAssumed Answered

Extracting Job Titles from Fields

Question asked by MatthewKingham on Dec 19, 2011
Latest reply on Dec 19, 2011 by philmodjunk


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.