>I am looking for the best way to delete items in table A based on items in Table B. I have been using the seek and find then delete method if you know what I mean. I know there is a better way using an SQL statement of some kind. Thanks for your help.
Try
DELETE FROM table_a ;
WHERE keyfield IN ( SELECT keyfield FROM table_b)
--sb--