Another Conditional Value List Question

[Courtney]

I've been working on this one for a while, and I can't seem to figure it out either on my own or from existing questions and answers in the forums.

I have the following tables and fields (formatted table:field)

Timesheet:Project Code

Timesheet:Filter Name

Projects:Project Code

Projects:Project Name

Projects:Status

Projects:Client Key

Client:Key

Client:Name

Timesheet:Project Code relates to Projects:Project Code and Projects:Client Key relates to Client:Key.

I also have a second Occurrence of the Timesheet table that is related by Timesheet:Filter Name to Client:Name.

Currently, the user selects a Timesheet:Filter Name and is provided a list that displays Projects:Project Code and Projects:Project Name. It displays only Projects that are related through Projects:Client Key=Client:Key.

Now I need to filter the list again to only show Projects where Projects:Status="Active".

I've tried various uses of a global text field filled with "Active" to match to the Projects table, but I've been looking at this so long I'm just confusing myself.

Any advice?

[The Big Bear]

Courtney

You need to make another relationship using the field that you have the first value list attached to. Use that relationship for the second value list.

See attached file

condtionalvalue.zip