Error message when using Forms

[ashleyangell]

I have three forms that are linked. When I input information to the linked forms and then try to save it, an error message pops up that says, "You cannot add or change a record because a related record is required in table "XYZ".

Can ANYONE help me with this? I am about to go crazy!!!

Thank you so much!!!

Ashley

 

[GumbyD]

Ashley -

You are having Refential Integrity issues. The error you are getting is coming up because of the way your tables are keyed and joined together. Since I cannot see the tables I would guess that you have a one to one relationship - check the keys on your tables if two of them have the same field as their key then you have a one to one join. When you insert a record on the form into one of the tables the other tables does not have a record so the join will not let the save operation continue and you will then get the error. You may also be getting this error because you are entering data into a table but the value you have selected for a foreign key (primary key of a related table) is not in the related table yet.

I hope that makes sense.

Good Luck.

GumbyD

 

[GumbyD]

Thank you for the e-mail. Glad that your database is happy now!

GumbyD