I've got two unrelated tables (table1 & table2), each with a text field called [DATA1].
I want to delete records in table2 only, if there is a duplicate value in [DATA1]
(So there will be no duplicates).
So I created a query with a [DATA1] <==> [DATA1] relationship, and it shows up any duplicates. However, deleting records within this query, deletes duplicate records in both tables, which is not what I want.
I could do it in a roundabout way by manually marking the records for deletion, within the above query (in another field) and then running a delete query.
I will need to delete duplicates regularly, so I need an efficient one click solution (probably using RunSQL a few times from a command button).