How to show combo items based on ID

[shabzo]

I have a table called Vitals with the following fields. Id(PK),PatientID,ConsultDate,Dependents(type combobox)

I then have a table called Dependents with the field ID(PK),PatientID,Dependents,etc
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)which 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.Dependents 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.

[shah1419]

trying to recreate its relation in forms. hope this would work...