I have created an inner join on two same field names in two tables A and B. There is a double inner join on the fields: Last Name and ID.
In design view, I have indicated the criteria that Table A 'Last Name' = Table B 'Last Name', and the same for ID field.
I will be deleting the records from Table A, where Last Name and ID are the same between Tables A and B.
I prefer to set this up in Design View, but when I submit, I get the error message 'Specify the Table' even though this is already done in the Design View parameters:
Field: Last Name (and ID)
Criteria: as mentioned above, inner join on both Last Name and ID
Therefore I have two field parameters in Design View, one for Last Name and one for ID
Hope this makes sense.