Connect foreign keys with Id Keys

[Spidey]

Hi,

I am a novice in database design. In the relationships table in filemaker, is it the best way to create id numbers for each table and connect to each other and then get the related field names if needed? Thanks.

Do you create a built-in primary key even though there is a unique key available?

K.C.

Edited December 2, 2010 by Guest

[Vaughan]

Table relationships are like the baggage checkin at the airport:

1) each traveller gets a unique number that identifies them

2) all of their luggage gets tagged with the travellers unique number

In the case of the database, the "master" or parent record has a "primary key" field that needs to be unique and invariant. Each of the child records has a "foreign key" field that records what the parent record's id is.

The easiest method to create primary keys is with an auto-enter serial number.