AboutScottgem Expertise I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
Experience I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.
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
