Schema and Method query

[Greg Hains]

Hi.

I am having a problem getting my head around the best way to achieve a certain job. I need to be able to have drop down boxes on fields that bring up only information related to the previous field, thus drilling down to find specific items.

I'll keep it as succinct as possible.

I need to draw up quotes. I need a table to have a list of items. For this example, I bring up "Car" in the first field, "Red" in the second field, then "Cherry" or Fire Engine" in the third field. Assuming that the only item in the first field that has "Red" as a subsequent choice, how do I limit the second, then third (etc) fields to narrow down what can be selected.

What woud be the structure of the tables, and would the search just be Finds and Constrains or?...

Once the item has been found, then we copy that info to another field, then reset the search process to do another item.

Has anybody already got a simple example I can work from please?

Thanks in advance.

Greg

[Ocean West]

This is referred to Dependent Value Lists or / Hierarchy Value Lists.

http://www.filemakermagazine.com/videos/hierarchical-value-lists-dependent-value-lists.html

[Greg Hains]

Hi Stephen,

Thanks for that - I might have to subscribe to ISO to get the full video to see how that works.

Exactly what I'm looking for.

Cheers,

Greg

[comment]

Alternatively, you could search here for "+conditional +value +list"...