Conditional/cascading menus

[Louisa]

Hi,

I'm working with pop-up menus in FMP 5. I want to restrict the choices possible in a second menu based on their choice in a first one, ie a conditional/cascading menu structure.

I've seen solutions to this problem for v. 3 and 4 which are huge and labourious, but I think it's supposed to be easier in v. 5.

Any help would be great thanks!

[dickiedyce]

You need to create a relationship based on the value of the firrst pop-up menu's field. You can then use the new define value list based on a relation.

Suppose you want to choose objects using a pop-up menu of animal, vegetable and mineral, followed by a menu to choose between the different types.

Create a separate file with two text fields;

Type: either animal, vegetable or mineral

Object Name: i.e. cabbage, car, Cassius Clay or whatever.

Create as many records as you need for your object lists.

Now in your main file create a realtion to this second file through the first pop-up field you want to use, and set it to use an ordinnary value defined by the contents of the Type field in the second database.

Now you can add your second menu, usinng a value list based on the realtion you've just created.

Hope that makes sense - if not, drop me a line and I'll email you an example.

[This message has been edited by dickiedyce (edited May 14, 2000).]

[Louisa]

This worked great thanks!

louisa