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!