Help on Established Relationships
I have the Foods table were several characteristics of foods are recorded. One of the characteristic is the scientific name of each food.
I have established the relationships shown on the attached picture. What I would like to achieve is to select the Genus for each food type and have FM to fill in all the related fields: Kingdom, Phylum/Division, Class, Order, Family, Genus. There is a one to many relationship for the fields previously listed.
In the Foods layout I have, among many others; the following fields:
Food:Genus attached to the Genus Value List:"Genus::__kpGenusID" and "Genus::Genus"
So I choose the value for the Food:Genus field and I expect that by doing so, FM will fill in the values for the following fields:
Any hint about what is wrong in the established relationship or layout is much appreciated.