Help with allowing duplicate records

[Mschneider331]

Hello,

I have created 3 tables labeled:


Patients
Appointments
Doctors.

Once I input all the data into the fields I got to the last line I was entering in the Appointment records, and that's when it told me I could not enter the
data "you cannot add or change a record because a related records is required in "patient"

I have attached the file if anyone can tell me what I'm doing wrong.

[ItsMe]

It sounds like you created a constraint when you defined a relationship in the Relationships Window requiring a record in table Patients. Are you trying to create a new doctor that does not have any patients? Maybe you can assign a patient to the new doctor before committing the record to the table.