Use drop down menus to filter subsequent options

[Fensterbaby]

I don't know if this is a calculations or function related question or what.

I have a portal that allows me to create line items of services ordered by a client.

I would like to have a popup menu that allows selection of a service type (lodging, transport, etc) then a second popup that is filtered by the first type menu.

So for example if I selected "Lodging" from the first menu then the second menu would only contain lodging options.

thanks for any help or advice

GF

Edited January 20, 2009 by Guest

[aldipalo]

What you are looking for is a "Conditional Value List." If you do a search for Conditional+Value+List you will get many postings to review. I've also attached a simple file showing you how it is done. I picked this up on the forum a few years ago and do not remember who posted it.

HTH

Conditioanl_Value_List.zip