Expert: Scottgem - 7/14/2009

Question
Hi Scott,

I have not been successful.  I think you helped me before.  I am trying to create a relationship (in access 2007) to relate 4 tables.  1.  Caller, 2. Question, 3. Pharmacist, 4. Claimant.

A pharmacist and caller will be be connected to many claimant numbers and questions.

One question will be related to one caller and one claimant.

What is the best way to set up (name) the Primary keys and Foreign keys.  I tried to follow the last diagram but it didn't work :(

Answer
I name my primnary keys using the convention:

tablename % ID

example CallerID, QuestionID, etc. My foreign keys use the same name where possible.

CallerID and PharmacistID are foreign keys in your In your Claimant and Question tables. Also ClaimantID is a FK in the Question table.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA