Link information in one table to another table

  • Thread starter Thread starter NDClark
  • Start date Start date
N

NDClark

I have a Patient form / table for basic information. Name, Birthdate ect.

I also have another table I call Health Records. This table is for the
specifics of a Doctor visit for all patients.

I want to be able to click on a record date on the Patient form and open
another form to see or add the specifics of a particular Doctor Visit for
that patient.

What is the best way to go about this? I have tried to put a subform on the
original Patient form displaying all the visits for that patient. I end up
seeing all the visits for all the patients. Or I get the Parameter dialog
box asking for a ID for the record.
 
NDClark -

It sounds like your subform is not properly linked to the main form. In
design mode, click on the subform and look at the properties, data tab. The
Link Child Fields and Link Master Fields should contain the field that is the
key in the Patient table (PatientID) and the foreign key (PatientID) in the
DoctorVisit table.
 
Thanks Daryl! That was the problem.

Daryl S said:
NDClark -

It sounds like your subform is not properly linked to the main form. In
design mode, click on the subform and look at the properties, data tab. The
Link Child Fields and Link Master Fields should contain the field that is the
key in the Patient table (PatientID) and the foreign key (PatientID) in the
DoctorVisit table.
Click to expand...
 
Back
Top