No I don't - the primary key of tblPatientProtocolActivity doesn't relate to
any table.

The primary key from tblPatient is related to tblPatientProtocolActivity by
virtue of the primary key in tblPatient being the foreign key in
tblPatientProtocolActivity.

Similarly, the primary key in tblProtocol is a foreign key within
tblPatientProtocolActivity.


--
Thanks for your time!


"John Vinson" wrote:

On Wed, 27 Dec 2006 16:21:01 -0800, NC_Sue
wrote:

My Subform is based on tblPatientProtocolActivity; I have a Combo
Box control on the subform, bound to Protocol_ID, and based on
tblProtocol; the Protocol_ID is the bound column of the combo
box... I just checked all of these things and they are true statements.


There is something we're not communicating!

Open your Relationships window and View All.

The only relationships you've mentioned are from tblProtocol to
tblPatientProtocolActivity, by Protocol_ID; and from tblPatients to
tblPatientProtocolActivity, by Patient_ID. Is that correct? Do you
have any relationships from the Primary Key of
tblPatientProtocolActivity to any other table (based on what you've
said, you shouldn't)?

John W. Vinson[MVP]