By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 2,121 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

Deleting from the query's datasheet view, from both tables?

P: n/a
ET
We have two tables... one with primary key ID and second table with
secondary key to the ID in the first table...

Now, they query pulls records from both tables, looks like this:
SELECT
tblCell_Sat_Phone_Main.ID,
tblCell_Sat_Phone_Main.[Asset Number],
tblCell_Sat_Phone_Main.[Cell Number],
tblCell_Sat_Phone_History.Location,
tblCell_Sat_Phone_History.[First Name],
tblCell_Sat_Phone_History.[Last Name],
tblCell_Sat_Phone_History.[Date Issued]
FROM tblCell_Sat_Phone_Main INNER JOIN tblCell_Sat_Phone_History ON
tblCell_Sat_Phone_Main.ID = tblCell_Sat_Phone_History.ID;

Now, when you run the query, the results come back, and you can
highlight the row in record set of query in datasheet view,
and then delete the row in datasheet, but, what happens is that only
the record from secondary table is deleted, but not from the primary...
In other words, the record in Cell_Sat_Phone_History table is deleted,
but the cell phone record in primary table still is showing record,
with cell phone, asset number etc...

Is there a way to delete from both tables when deleting a row from
query's record set in datasheet view?
Thank you!

Dec 5 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.