On Wed, 27 Dec 2006 09:49:00 -0800, NC_Sue
wrote:

I have 2 forms with subforms (as I need to be able to look @ data both ways).
One is a form with the "master form" source being tblProtocols & the "child
form" being tblPatientProtocolActivity. One is a form whose master is
tblPatients with the child being tblPatientProtocolActivity. I can't enter a
new patient into either one although I can assign a patient to a new protocol
without difficulty.

With a form/subform setup, you can enter data into the mainform, and
into tblPatientProdocolActivity - but there's no (instant) way to add
data to BOTH "one" side tables on the same form. That is, if you have
to enter a new patient, AND a new protocol, AND assign the patient to
that protocol, you need to bring up another form in some way (either
by opening a form separately, or using VBA code in a combo box's Not
In List event).

Could my problem be that I've enforced referential integrity within my
relationships?

Only if you've done it wrong. What tables are related to which?

John W. Vinson[MVP]