S
staceland
Hello,
I have created a database for keeping my family's medical history with
4 linked tables:
[Patients]
[Physicians]
[Services]
[Service_Providers]
The main form [Patients] has two subforms:
Patients_frm
Physicians_sfrm
Services_sfrm (Service_Providers_tbl was somehow merged with the
Services_tbl to form this subform
by the forms wizard)
Everything works fine except when I try to add data to the
Service_Providers portion of the Services_sfrm.
I get the error "Cannot add record(s); join key of table
'Service_Providers_tbl' not in recordset.
I can add the data in the linked table view. Just not in form view.
I used the forms wizard to create the forms so I would think that
Access would have coded everything correctly. Any ideas?
Thanks
Staceland
I have created a database for keeping my family's medical history with
4 linked tables:
[Patients]
[Physicians]
[Services]
[Service_Providers]
The main form [Patients] has two subforms:
Patients_frm
Physicians_sfrm
Services_sfrm (Service_Providers_tbl was somehow merged with the
Services_tbl to form this subform
by the forms wizard)
Everything works fine except when I try to add data to the
Service_Providers portion of the Services_sfrm.
I get the error "Cannot add record(s); join key of table
'Service_Providers_tbl' not in recordset.
I can add the data in the linked table view. Just not in form view.
I used the forms wizard to create the forms so I would think that
Access would have coded everything correctly. Any ideas?
Thanks
Staceland