We have a task system we have developed over a number of years and which we are very happy with.

Each task is either "in Studio" or "Delivered". Each Task has an "Task ID" and a "Task Description".

It also has a time sheet component. Currently each graphic designer must type in the "Task ID" which allows them to allocate time to the appropriate task.

Instead of that I would like them to select from a drop-down list of "Task Descriptions", which is simple enough. However I want it to display only the "In Studio" tasks allocated to a specific designer.

You need a join table btw Designer(Staff) and Tasks. This table will have a StaffID and TaskID and I'd lookup Task Type (in Studio or Delivered). When entering a new time sheet record, they need to specify their StaffID (or just have new timesheets created from a Staff Record (that'll let you put the StaffID in the timesheet for them via the script). Then create a conditional value list using a relationship from Timesheets to the join table by StaffID and Type=In Studio. Use a popup menu to display the choices, and show only the value from the second field.

Search the forum for demos of conditional value lists.

Thanks, I can make it work in a simplified db. Now I just need to try to apply it to the more complex actual db.