3 tables with common field - What relationship do I use?

R

Raj Patel

Hello,

I am a newbite to Access and have a question.

I have three tables in a medical database that are of concern:

tblQuestions
------------
PK - QuestionID
FK - ExamID
Number

tblEncounters
-------------
PK - EncounterID
FK - ExamID
Date
Location

tblHospitalizations
-------------------
PK - HospitalizationID
FK - PatientID
AdmitDate
LocationType
LocationName
KeywordPresent

All of these tables relate to a final table that looks like this:

tblDiagnoses
------------
DiagnosisID
Reason
Code
SP

Each on of the tables can had multiple diagnoses. Right now I have
created many-to-many relationships between these three tables and a
single tblDiagnoses table. This way each record in the three tables
can have multiple diagnoses. I am not sure whether this is the proper
way to setup this relationship. How else can/should this be done? A
one-to-many relationship seems right, but that will not work since
there are three tables that all relate to tblDiagnoses.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

relationships of 3 tables 6
reconstruct table that was normalized into several tables 3
Cannot create one to many relationship 6
Military Unit Database 1
Relationship/Comb Box Problem 4
Normalising a Many-to-Many Relationship 4
set up tables with proper relationship 1
Count unique field1 combined with count field2, both grouped andungrouped 3

Top