Cannot add or change record

[skid]

Hi!

I have a master-detail (patient and its consultations) form, the consultation table used to be implemented as a subform just below the patient data and all works fine. But I figured out that it's better that i'll just have a button on the patient form that calls the consultations form. I have done it thru the wizard. The problem is when I started inserting data from the consultation table it says "You cannot add or update a record because a related record is required in table 'patient'. I don't know what I have done wrong or what property on the subform has changed . Please help.

Thanks,
skid

 

[DW]

Your problem lies in Relationships.

Have you used referential integrity.

Do a search, you will find lods on this.

Good Luck.

Dave