I have a table called Vitals with the following fields. Id(PK),PatientI D,ConsultDate,D ependents(type combobox)
I then have a table called Dependents with the field ID(PK),PatientI D,Dependents,et c
This is also a forn that gets updated whenever there is a new patient or dependent.
In my main form called Patients , the fields are PatientID(PK)wh ich is an autonumber and other fields.
In this fornm i have created a subform for Vitals. The parent link works fine with the PatientID.
The problem I am having is in the combobox of Vitals in the subform. This the rowsource for combobox :SELECT Dependents.Depe ndents FROM Dependents;
example PatienID 65 is selected in my Main form. Vitals also shows the same PatientID 65. But when I go to select dependents it shows all the patients dependents and not for PatiendID65.
I then have a table called Dependents with the field ID(PK),PatientI D,Dependents,et c
This is also a forn that gets updated whenever there is a new patient or dependent.
In my main form called Patients , the fields are PatientID(PK)wh ich is an autonumber and other fields.
In this fornm i have created a subform for Vitals. The parent link works fine with the PatientID.
The problem I am having is in the combobox of Vitals in the subform. This the rowsource for combobox :SELECT Dependents.Depe ndents FROM Dependents;
example PatienID 65 is selected in my Main form. Vitals also shows the same PatientID 65. But when I go to select dependents it shows all the patients dependents and not for PatiendID65.
Comment