Value lists and pop up list/menu

[fish6313]

This is similar to another question on this post but not exactly the same and that question wasn't answered fully anyway so here goes.

I want to have a pop up list were it accesses a value list. if i select automotive it gives me a second value list where i can choose car, truck, motorbike etc. if i choose car, it gives me another list that says ford, holden, fiat etc. if i select ford, it gives me another list that says falcon, fairlane, fairmont, mustang etc.

The new value list is based on the choice i make in each value list along the way. Can it be done, is it easy or very tricky and does it say how in the instruction manual (i can't find it)

I saw something about odbc and thought i was on the way but it's a whole new can of worms.

Thanks in advance.

[andygaunt]

OK, you want a conditional value list. Because of the number of options, your best bet is to create a database for the values.

This database will hold fields of

Category ( for automotive etc)

Type (for car, truck etc)

Manufacturer (for Ford etc)

Model ( for Falcon etc)

Each record will have the information stored in it, resulting in many records for all the possibilities.

Then, using calculation fields to find those values that are more than two deep, you can conditionally change the results of a popup

See attached file for an example. Open Automotive.fp5

[Lee Smith]

Hi Andy,

Very nice CVL demo.

Thanks for sharing,

Lee

[jasonwood]

I didn't look at the file, but maybe you should post it with the "Sample Files"... since so many people are always asking about conditional value lists.

[Lee Smith]

It's attached to Andy's reply above.

[ldebondt]

Andy,

Was unable to open attachment. Is this a file strictly for MAC?? Could you include as a ZIP file? Thanks,

[jasonwood]

Windows users can download the decompression utility commonly used on Macs at http://www.aladdinsys.com/