Needs explanation Please !!

[jd9027]

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 !!

[Ender]

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

[jd9027]

Thank you very much Ender