Referential integrity not being enforced

You may have a PatientID without having entered a FName and LName. This is
probably the record you are entering visits against.
Modify your table to make LName a required field.



"Kurt" wrote:

Despite enforcing referential integrity between my tables, I am able to
create a record in the child table without a corresponding record in the
parent table.

For example, tblPatients has a one-to-many relationship to tblVisits. (A
patient can have many visits.) They are linked by PatientID.

tblPatients
------------
PatientID (PK)
FName
LName
…

tblVisits
------------
VisitID (PK)
PatientID
VisitDate
VisitLocation
…

The main form, frmPatients, has one subform, fsubVisits. They are linked by
PatientID.

I can enter any number of records into fsubVisits without ever entering a
patient, and I don’t get the usual error message when I try to leave the
record or subform.

Any idea what’s overriding the referential integrity?

Thanks.

Kurt