I have a database and in this databases I have a record of products. Each product has a type. The type can be of different value, i.e. camera, storage, etc.

I want to be able to get all the different types and place them in a pulldown menu such that when they hit the button "go to type" it will go to a specific layout.

The product records are created by importing a product listing which has a a part number, type, price and some notes.

Is there a way to create a pulldown menu in a layour based on the unique product types

found in the product db. Right now I have a button for each product type which unfortunately if there is a new product listed in the file, it will not show up.

I need the choices to be dynamic.

Thanks

Check this this recent thread and see if this is what you mean.

Re: Activate a script within a field

HTH

Lee

Sorry it's not what i need. I need a pulldown menu such as those you find on the web. Such as the Post Icon pulldown menu found here when creating a message or reply.

The options of the pulldown menu will be based on the different categories found in the category field of the product database.

If the record in the product database has "video cameras", "storage media", "DVD", and others then the pulldown will have as its pulldown options:

video camera

storage media

dvd

The pulldown needs be dynamic content, what is found in the product database should reflect what is in the pulldown menu.

Thanks for any help on this. I haven't found anything on pulldown menus in FMPro.

Have you thought about using a conditional value list?

I may misunderstand your need here, but it sounds like you want to go to a certain layout based on which Type of object they choose. How about:

1) a Global text field ("TypeChosen"), with a pulldown menu that is a value list defined by all the Type entries in the database

2) a second global text field ("TypeLayout"), that is a calculation such as:

If TypeChosen = "camera", "CameraLayout"

If TypeChosen = "storage", "StorageLayout"

etc.

3) Let the user see TypeChosen with its pulldown menu, but not TypeLayout. Put a button next to it that will Go To Layout (Defined By TypeLayout)

The button will go to whatever field TypeLayout says. TypeLayout will calculate the appropriate layout name (hardcoded, I'm afraid) based on whatever they choose for TypeChosen.

The pulldown menu will be dynamic, but layouts can't be dynamic in FMP, as far as I know.

McCormic, your suggestions is exactly what I needed. Thanks so much. It was the calculation field that I failed to realize.