June 7, 200520 yr I have attached an illustration for a database I am making in Filemaker 7 I am relatively new to this program and understands the basics of FMPro ( I believe so ; ) In the attached illustration, I wanted to know which fields should I be linking in the relationships editor, whether my thought process as illustrated in the picture will work to implement the logic. Please Help !!
June 7, 200520 yr You need to add the corresponding foreign keys to the Type table and SubType table, and link each primary key from the parent table to the foreign key in the child table. Type will have a FruitID field and SubType will have a TypeID field. The relationships will then be: Fruit <=> Type Fruit::FruitID = Type::FruitID Type <=> SubType Type::TypeID = SubType::TypeID
Create an account or sign in to comment