Update Query Need some help

[MarkNie]

Hi

I am currently using an update query to update information from one table to another. Everytime I click on the update query it deletes the information from the table I am getting the information from and I don't want that to happen.

I would also like well don't know if it can be done but everytime I delete the record in the table that I am copying from I want it to delete the information in the other table too.

Any help on this would be great.
Thanks
Mark

 

[PHV]

How an update query may delete records ?
Could you please post the SQL code of this strange update query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MarkNie]

PHV

I dont' have any code for this just wanted to know if it is possible or if there is another way I must do it.

This is what I have for the first bit where the query copies the information accros but then delete's it from the table.

UPDATE qrySLA INNER JOIN tblTracking ON qrySLA.TrackingID = tblTracking.TrackingID SET qrySLA.[Date] = [tblTracking.IndexProcessingDate];

Thanks
Mark

 

[PHV]

This SQL code deletes informations from the tblTracking table ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886