On Wed, 27 Dec 2006 13:31:01 -0800, NC_Sue
wrote:

tblProtocol's primary key, Protocol_ID, is the foreign key in
tblPatientProtocolActivity, i.e. in the relationship window I drug
Protocol_ID from tblProtocol to tblPatientProtocolActivity.

Similarly, tblPatient's primary key, Pt_ID, is the foreign key in
tblPatientProtocolActivity, i.e. in the relationship window I drug Pt_ID from
tblPatient to tblPatientProtocolActivity.

Just for kicks, I unclicked "enforce referential integrity" on the
relationships above, and it now works fine.

It's only working because by unclicking enforcement, you're allowing
garbage data into the database!! Disabling the speedometer on your car
won't protect you from speeding tickets or accidents!

There's *something* wrong with your Subform. You should have the
Subform based on tblPatientProtocolActivity; you should have a Combo
Box control on the subform, bound to Protocol_ID, and based on
tblProtocol; the Protocol_ID should be the bound column of the combo
box.


John W. Vinson[MVP]