Its like

I have 2 tables all related to each other in some way

when i try to delete the contenst of 1 table it says" child in other " so cannot delete

in the 2nd table if i try to insert..it says "record not found in 1st table cause 1 feild related to a column in first table

Now i get a file every 15 days for thses updates and delete
1 file for each table
he file contains the delete and insert statements

if i try to execute the 1st file it inserts properly but cannot delete as child xists

if i try to execute 2nd first it deleted properly but cannot insert as primary not fiund..
i hope u c what the problem is

i can drop the constraint and recreate it
but is there ay other way out?

thanx