Problem with DataSet Relations

Question

Hello ! I'm trying to configure a relation between two tables in a dataset. It works well when I open the form at the first time but when I close the form and open it again (still in runtime) I get the following error message: Faild to enable constraints. One or more rows contain values violating non-null unique or foreign-key constraints. I have no idea what table may cause this error and why it doesn't happen at the first run. I tried to dispose and clear the dataset when I close the form but it didn't help. Thanks in advanced Tom.

p.jones · Answer

You have mismatching parent-child keys such as a child with a key value that doesn't exist in the parent table. Look at your values and look at how they are getting there.