Conditional Value List Help

[Hefty517]

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.

[Hefty517]

Is anyone able to help on this? Is there more information I need to provide?

Thanks in advance!

[Ron Cates]

Add a calculation field to your Time Log table with the calculation set to "open" then add another criteria to the relationship you already have in place that filters projects something like

Time Log::NewCalcField = Projects::Status.

Then your valuelist will only show project numbers from projects that have a status of "open"

[Hefty517]

Add a calculation field to your Time Log table with the calculation set to "open" then add another criteria to the relationship you already have in place that filters projects something like

Time Log::NewCalcField = Projects::Status.

Then your valuelist will only show project numbers from projects that have a status of "open"

Thanks so much...that did it! I really appreciate your help.