This should be a simple thing to do, but I am banging my head against the wall.
I have a table that stores Patient names and IDs (tblPatientID) and another that stored basic demographic information (tblPatientData). I need to allow users to select a record from tblPatientData by selecting the Patient name from a Drop Down. These tables have a one-to-one relationship on PatientID -- a numeric field included in both tables.
I currently have a form using tblPatientID as the data source - this form has a combo box allowing the user to select the name; however, the control is bound to the Patient ID. There is a subform for the tblPatientData data. The forms have the parent and child links set to PatientID. Selecting a patient from the combo box on the main form, does display the proper data in the subform, however, when I try to close the form, I get an error that "Changes are not successful because they would create duplicate values in the index, primary key or relationship"
Any advice? Should I have this set up a totally different way? Am I making this a lot more difficult than it is... Thanks!
ok - here I am responding to my own post... instead of doing a form/subform - should I just be creating a query that includes both tables and then using a control to create a filter?
Sorry... just got this big Access project dumped on me and it's been about a decade since I've used Access -- I feel like I've forgotten EVERYTHING! Any nudges in the right direction are greatly appreciated!