Can not delete a record or chage a ecord because there are related records in tblOrde

odrap

Registered User.
Local time
Today, 09:01
Joined
Dec 16, 2008
Messages
156
I have a form with a subform to manage orders. The suborder is frelated to the parentform bij OrderID.
Entering orders as well as changing orders works very well. But the moment i go from the subform back to the parentform to close the form i get the message:
cannot delete or change the record because there are related records in tblOrderdetails.
What can be the reason for this.
 
Access is preventing you from creating "bad" data. This is a good thing!

You are violating the Referential Integrity of the data in some way.
 
Thanks for the help
 

Users who are viewing this thread

Back
Top Bottom