August 13, 200520 yr 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
August 14, 200520 yr 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
August 16, 200520 yr Author Soren, Thanks for your help. I will poke around in this direction. Jarvis
Create an account or sign in to comment