I am trying to move my data and app from ms access to sql, but before i do that i need to enforce referential integrity to make sure there is no issues with my data. Should have done it from the start, just didnt know that the feature existed.
When i go to ms access and edit my relationships and enforce referential integrity, i get an error that my purshase table vilates integrity rules.
I google'd around and found a query to find which records are the trouble making ones, and used the following query:
SELECT Order.CustomerID
FROM Order
WHERE NOT EXISTS
(SELECT Customer.ID
FROM Customer);
I found a couple trouble making records, and after analysing data in them I have deleted them.
When I went back to Enforce Referential Integrity, I am getting the same error.
Am I missing something?
...
Go to the complete details ...