>>In another thread, which almost exausted me, he told, that he doesn't have PK in his tables, since tables are produced from Excel. So, I'm thinking about
>>delete from Original where recno() in (select RecNum from CopiedRecords). That's from the top of my head, I hadn't tried. Do you think, it would work? Otherwise he needs a loop, but I do not like this idea.
>
>Methinks that as soon as the data is imported into whatever system he uses, he should add a primary key, to facilitate further manipulation.
I agree completely.
>IMNSHO, recno() is doubtful. A loop would be safer, but it might also be slower.
So true :)
If it's not broken, fix it until it is.
My Blog