AnsweredAssumed Answered

New - Fundamental Design question - foreign keys

Question asked by randy on Mar 6, 2009
Latest reply on Mar 7, 2009 by comment_1

Title

New - Fundamental Design question - foreign keys

Post

New to FM, have bought FM Pro 10 Missing Manual (read chapter 7) and White Paper for FMP Novices.  Attempting to make Entity Relationship Diagram.  Still unclear on question of foreign keys.

 

As I understand it, every table must have a unique primary key field.  In a 1-many relationship the many table needs a foreign key for the 1 side.  Apparently the 1 side never need a foreign key for the many table?

 

What about a 1-1 relationship?  Is a foreign key necessary on either (or both) side(s)?  Or should not exist on either side?

 

The White Paper is way too advanced beyond such a basic question, and having re-read the Missing Manual Chapter 3 times, I am still unclear on this.  Any help would be appreciated.  Thanks. 

Outcomes