468,275 Members | 1,855 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,275 developers. It's quick & easy.

How to show combo items based on ID

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.
Nov 25 '13 #1
1 4872
trying to recreate its relation in forms. hope this would work...
Nov 25 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Cassie Pennington | last post: by
3 posts views Thread by MervinJadhav | last post: by
1 post views Thread by Mike Stunn | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.