OK, that's all well and good, but I left another detail out. <BR><BR>The amount of rows I want to delete from the first table is 516 and each one of those is referenced several times in table2.

You can edit values from teh parent table on this page, but you can't edit the values from a child table. By selecting the company category from the repeat region, you are taken to the ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.