Hi I'm having problems with a value list. Here's the scenario: I've got 2 tables:
Projects and Resources (Staff) which are related on Project No.
A project can have numerous resources, these are added by using a User ID.
(When the user logs onto the system their User ID is stored.)
I have a Timesheet table which allows the current user to enter what projects they've been working on.
I want a drop down list to show only Projects that have a Status = "Approved" and End Date < today and where the current user is a Resource. So the user can only select valid projects.