On Thu, 28 Dec 2006 15:45:01 -0800, NC_Sue
wrote:

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.

I'm baffled then at why you're getting this message.

I don't usually do this (others take note - unsolicited emails of
databases will get a consulting contract proposal in reply g) but
could you compact your database, Zip it, and email it to me at

jvinson at wysard of info dot com

(edit out the blanks and the punctuation). I'll try to see what is
causing this bizarre error.

John W. Vinson[MVP]