I have an append query that Im getting key validation errors on..in help it suggested I delete the links and then relink..but of course I couldnt find out how in the help system..

any ideas?

update:

yup thats what I had to do..now if I could just automate the process =)

Rather than removing the RI, you should re-arrange your table load order so that the tables are loaded in an order that will not cause RI errors.

Can you expound a little? Im not sure what you mean by table load orders.


Thanks,

The Razzzz

If you have an Order table that has a foreign key of CustomerId that refers to a customer table, you need to load the customer table before you can load the Order table. If you don't you will get RI errors because the customer record for an order will not already exist in the customer table.