AnsweredAssumed Answered

Help on Established Relationships

Question asked by NaturSalus on Jul 26, 2011
Latest reply on Jul 27, 2011 by philmodjunk

Title

Help on Established Relationships

Post

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:

Kingdom::KingdomName

Phylum_Division::PhylumDivisionName

Class::ClassName

Order::OrderName

Family::FamilyName

Food:Genus attached to the Genus Value List:"Genus::__kpGenusID" and "Genus::Genus"

Food::Scientific Name

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:

Kingdom::KingdomName

Phylum_Division::PhylumDivisionName

Class::ClassName

Order::OrderName

Family::FamilyName

Any hint about what is wrong in the established relationship or layout is much appreciated.

Thanks

food_database.jpg

Outcomes