1 Reply Latest reply on Dec 19, 2011 8:57 AM by philmodjunk

    Extracting Job Titles from Fields

    MatthewKingham

      Title

      Extracting Job Titles from Fields

      Post

      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.