I'm working on a Master Access Databases with A General Form and several Subforms. My issue is that I want the Access Information, Contact Information, and Financial Information Subforms to the General Information Form to have 1-to-1 relationhips. However, when I try this by with or without enforcing referential integrity, the information on the subform is showing up on all the records and the option to add more records is there (when it shouldn't be).
Can someone please tell me what I am doing wrong.
Also, I get an error, when I try to update the Financial tab. My relationship and error pics are attached.
I'm looking forwards to your responses, I've been trying to figure out on my own for over a week :(