Transfer records

[Dina01]

Hello,

I create a db and I have 2 tables that are linked to my db named BackUp.....Everything works fine, but once my records get transfered into my table named BackUp, I need the original db to delete all the record in the tables, I create DELETE query and it works fine, but since my tables are linked to the other table in the BackUp db, well the records are DELETED.....Can anyone please tell me how to do this...

 

[The_Doc_Man]

Do you have a one-to-one relationship between records in your main table and in the linked tables in the BACKUP DB? And is relational integrity (Cascade delete) turned on for those relationships if they exist?

If the Cascade Delete option is turned on for the relationship, turn it off.

If there is no relationship involved, then I don't know why this would happen as you describe.

 

[Dina01]

Hello,

I have No Relatioship...

I have to delete queried.....

1.
DELETE DataTracking_tb.*
FROM DataTracking_tb;

and
2.
DELETE AgentTrackingModification_tb.*
FROM AgentTrackingModification_tb;

The linked tables are DataTracking_tb and AgentTrackingModification_tb

but when I run my delete queries, I only want to delte the records from the Origianl db named Dispatch and not my records in my db named BackUp...