Relationship?

[Anke]

Dear Listmembers,

I need your help.

I am new in the FM and I am lost with this problem...

I am making now a database for Art History Slide Archive where all the slides are sorted by their present location. I wish to do the following (and cannot find the solution):

1) First List - Country (choose one)

2) Second List - City - in this particular country (this list should change itself accordingly to the country chosen in the First List)

3) Third List - Collection - with all existing collections from the City chosen from the Second List (this list should change itself accordingly to the City chosen in the Second List).

Meanwhile I've got hundreds of names for the Collection List... What should I do to create this kind of relationship between the lists?

Please, HELP me !

Thanks,

Anke

[email protected]

[TSC]

The first list, would be a standard pop-up list.

Second, build a relationship based on country and make the value list a pop up based on the country relationship.

Third, build a relationship based on city. Value list would be a pop up based on the city relationship.

That should do it for you.

Tim Cormier

TSC

http://www.fmdeveloper.com

[The Shadow]

This is rather a lot to explain, take a look at this example file and follow along.

You no doubt have a seperate table with all the collections in it, with the country and city of origin listed. Look at the graph and see how I've added two new versions of the collections table with suggestive names, "collectionsByCountry" and "collectionsByCity".

Now, I'm able to define three new value lists, "All Countries", "Cities In Country", and "Collections In City".

- "All Countries": A simple list showing all countries present in the collections table.

- "Cities in Country": A list using the relationship "collectionsByCountry" to show only the cities in that country, you check the "include only related values" checkbox and set the start table to the table you need to use it from.

- "Collections in City": A list using the multi-criteria relationship "collectionsByCity" that restricts the set further to both the country and city matching. It is also a related valuelist, setup similar to the one above.

Then you go into layout mode, and set the field format to use these value lists at the appropriate spots.

Feel free to ask for further assistance, but this should get you started.

[Anke]

Dear Tim and Shadow,

Thank you very much. I (almost!) understood how to do it. Shadow's attachment was a great help.

Now I am trying to implement my knowledge to do the same in FM 5.5 (for the Uni Computer, they did not get the upgrade yet). Can anyone help me with it, please (stage 2 and 3)?

[The Shadow]

FM 5.5 is very similar. The collections table would be stored in another FM5 file, rather than the same file. You would define the relationships in your slides file that connect to the collections file.

In 5.5, the multi-criteria relationship is done with concatenated keys - create a calculation in both files called CountryCity that is defined as: Country & City

then relate these two new fields together for the "collectionsByCity" relationship.

The valuelists are defined in the slides file, using these same relationships.

[Anke]

Thanks alot.

I did it !! It works great.

Many thanks again.

A.

[Karma]

What format is the attached graph in?? i can't seem to open it without it turning into jumble

[-Queue-]

It's a StuffIt file, like the WinZip of Macs, go here to download it.

[Karma]

thanks for this...

it was a great help in getting me started...