Hello,
I am trying to develop a delete query (create->query design method). I have two tables utilized in the query, that have a relationship built with join property on two fields of : 1. Only include rows where the joined fields from both tables are equal. I am trying to essentially have Access delete any record in Table 1 where there is a match for these two fields found in the Table 2. It says an error of Specify the table containing the records you want to delete. What needs to be specified in the fields used in query section to have the query run as I intended?
Thanks