Several years ago(>10), I was able to set up a many-to-one
relationship which worked about 90% of the time. Never did get it to
work perfectly. Since I had other priorities, I put it aside.

Now, with FM Pro 9 Adv, I am not able to build the same tables. I am
attempting to build a data base of species rhododendrons showing a
relationship from any (many) species to its sub-section (one per
species) but several species pointing to one sub-section. Then
another table with the same structure from sub-section to section.
Then section to sub-genus and then sub-genus to genus.

This allows me to input the species name on a plant sheet and the
relationship validates my spelling of the species name and shows the
sub-section name.

I set up a layout with the subsection name and 20 occurrences of a
portal for species. It seems that this should be very simple.

Thanks,
Donald King

--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/