I have an Access relation database with a few tables.
Customer, order, process1, process11, process130 etc.
Customer Primary key is CID
Order tabel har Primary Key OrderID and Forreign Key CID
All the Processtables has ID as PrimaryKey and OrderID as Forreign Keys.
The relations are set to 1 to Many.
1 Customer -> Many Orders
1 Oder -> Many Processes
I have filled theese tables with data seperatly and the update works great.
But when I know want to change data in the Order-table the update fails because I have related posts in Process130-table.
I have set the DataSet.EnforceConstraints = False but that did not help.
I also update all the Process-tables before I try to update the Order-table but no luck.
Can anyone please give me a hint to what I am doing wrong?