Link information in one table to another table

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.
 
D

Daryl S

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.
 
N

NDClark

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.
 

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

Top