Conditional > Conditional Value Lists

[Jarvis]

I am working on a task list manager for my cabinetshop.

I have three fields: PART NAME and TASKS and COMPLETION STATUS.

PART NAME is populated from a pop up value list.

This value list contains the custom values: Door ---- Drawer -----Faceframe

TASKS are also generated with a pop up value list but this value list contains only related values. If you pick Doors your available TASKS only contain Door activities.

If you pick Drawers, all subsequent tasks choices are germane to Drawers.

COMPLETION STATUS is a simple radio button: Finished -----Not Finished

What I have so far is a simple conditional value list.

I would like to complicate this.

My goal is something like the following:

TASKS are still related to PARTS but are constrained by COMPLETION STATUS.

If you pick Doors, the task list now only contains tasks that are not yet finished.

If COMPLETION STATUS indicates the task is finished, this task is no longer available

to pick from.

I don't however want to completely remove the task from the value list because I will need

it for the next time I start to build a door.

I hope I explained this right.

This is kind of like theater seating.

You first select a price range for a ticket then select a remaining seat in that price level.

All the seats become available again for the next show.

Can anybody help me here?

Thanks,

Jarvis

[Søren Dyhr]

Well first off is it probably something like this you're after since you're on 7dev:

http://www.filemakerpros.com/FILTER.sit

But i can also be down with relations:

http://www.fmforums.com/threads/download.php?Number=133792

--sd