Originally Posted by
jzwp11
The observation table has a record for each observation time.
baseline, +1h, +2h, +4h, +6h, +10h...
So you would have records with 0, 1, 2, 4, 6,
These I assume are all in reference to the date of the visit. What are the 5 other observation points?
screen, baseline (0), +1h (1), +2h (2), +4h(4), +6(6), +10h(10), +24h(24), day8(168)
You make the connection in this table so there will be 9 records for each patient visit record in tblPatientVisit
tblPatientVisitObs
-pkPatientVisitObsID primary key, autonumber
-fkPatientVisitID foreign key to tblPatientVisits
-fkObsID foreign key to tblObservations