Query Creates Read-Only Recordset

[bhikku]

I want to delete a set of records within a table and I am using records from
another table as a reference. Table A contains the records I want to delete.
Table B contains the subset of records I'm using to identify the target
records. I have full access rights to both tables but when I run the query

"SELECT tblA.* FROM tblA INNER JOIN tblB ON tblA.ItemNo = tblB.ItemNo"

I get the error "operation must use an updateable query".

If Table A contains 100 records and I want to delete 50 specific records,
and Table B contains only those 50 records that match the target records in
Table A, how to I use Table B to delete the records from Table A?

Thank you for any help!

b

[pietlinden]

How about something like this:

DELETE tblChildRecords.SomeName, tblChildRecords.SomeNumber,
tblChildRecords.IDField
FROM tblChildRecords
WHERE (((tblChildRecords.SomeName) In (SELECT item FROM tblParent WHERE
ID<10));

Just us the IN clause and specify a valid subselect...