Is it possible to build a "tree" in filemaker?

So that I can chose in popup menus in many steps? For example: I chose a country in the first menu and then the second menu dispays only the cities in that spicific country. When I then chose a city the thierd meny displays the streets in that city.

Please help me anyone?!?

Thanks!

quote:

---

Originally posted by skywalker2000:

Is it possible to build a "tree" in filemaker?

So that I can chose in popup menus in many steps? For example: I chose a country in the first menu and then the second menu dispays only the cities in that spicific country. When I then chose a city the thierd meny displays the streets in that city.

Please help me anyone?!?

Thanks!

---

For the simpliest case you need three fields :

myID, parentID, isRoot

than create relationship

parentID-->myID (if you intend to present "menus" in one unique container) .

Otherwise, for the purpose of implementation you'll need as many global fields as is number of "menus" that you want to present and relationship for any of them, ie

gField1-->isRoot

gField2-->parentId

...

gFieldn-->parentId

To present the first menu set gField1 to 1(it is root)

To present second and consecutive menus

set gField2 to ID of it's parent

(if you are using portals to present items than clickin on portal row set field gField2 to RelName::myID)

HTH Dj

HTH

Dj

It's called "heirarchical menus", and involves related files.

Create another file with four fields: Country, City, and Street being ordinary text fields, and a calc field consisting of Country, a couple of spaces, and City.

Create a similar calc field in the main file

Create two relationships from the main file, one based on the Country field and one based on the calc fields.

Define a Value List in the main file ("Cities"). Have it equal values from another file, then choose "only related values", choose the "Country" relationship and the "City" field in the related file. Have the "City" field be a popup list using this value list.

Define another Value List based on the calc field relationship for Street.

I've emailed you a demo file that I did for a previous post on this same subject.

Russ Baker

[ March 26, 2002, 03:29 PM: Message edited by: Russell Baker ]