Value lists from found sets

[Jarvis]

I am building a task management solution.

It has three fields: PRODUCT > TASK > STATUS

PRODUCT is populated with products from pop up value list.

TASKS are generated from a value list that is related to the product value list. (If I select (PRODUCT 1) from the first list, the second list displays tasks that are germane only to (PRODUCT 1) etc.)

STATUS toggles "complete" or "not complete".

[color:red] Is there a way to make the TASK value list display related tasks, but only display the related tasks that are flagged as "not complete" in the STATUS field?

Thanks for any help,

Jarvis

[Søren Dyhr]

Is there a way to make the TASK value list display related tasks, but only display the related tasks that are flagged as "not complete" in the STATUS field?

Use the checkbox as the second link in a multi condition relationships def.

--sd

[Jarvis]

Soren,

Thanks for your help.

I will poke around in this direction.

Jarvis