relational fields?

[Anke]

Dear Listmembers,

I need your help.

I am new in the FM and I am lost with one 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]

[CobaltSky]

I have an uncomfortable feeling of deja-vu.

This question has already been asked and answered at:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB17&Number=106269&Forum=,All_Forums,&Words=&Searchpage=0&Limit=100&Main=106269&Search=true&where=&Name=&daterange=&newerval=&newertype=&olderval=&oldertype=&bodyprev=#Post106269

FWIW, duplicate posts are not considered to be good forum etiquette...