Find duplicates in external database
I have two databases: one for admittance (selection) and one for monitoring. The first one selects from thousands of subjects max. 100 subjects and the second one monitors the selected (admitted) subjects. Each year we will have one or two admittance process's.
Is there a way to check for duplicates (birth registration number) via relationships (same subject could not attend more than once)?
I now that I could import the selected records into the monitoring database, but if I find duplicates i have to delete those duplicates and to remake the selection again without the duplicates found.
Many thanks for your time,
Looking forward to hear news from yours,