Hi all,
Hoping someone can help me out here. I have a pretty standard "Time Log" table in which the employee can put the client, project number, task, and time. I also have a table for the projects, which contains the project number, client, due dates, status (Open, Complete, Hold, Canceled), information, etc.
In the Time Log table, the project number is a drop-down value list, so that once the client is picked, the value list only shows the project numbers related to that particular client, and this works perfectly. However, due to the sheer volume of projects we can have for each client throughout the year, I would like the drop-down list for project number to only show the related projects that are still open (won't show complete, canceled, or on-hold projects).
Any help would be greatly appreciated.