I've created a database for my office, but it needs some improvement. For each record in my database, there is the AutoNumber ID, and there is a unique subject ID for each person in this database. Sometimes, individuals are entered more than once w/ different IDs, but a little research on the end user's part reveals that the two records are actually the same person.
Is there any procedure that will allow an administrator to merge/combine records w/o losing the data? Better yet, w/o duplicating the data after the data has been merged?
Thanks for your help!
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Combine Records in MS Access
I've created a database for my office, but it needs some improvement. For each record in my database, there is the AutoNumber ID, and there is a unique subject ID for each person in this database. Sometimes, individuals are entered more than once w/ different IDs, but a little research on the end user's part reveals that the two records are actually the same person.
Is there any procedure that will allow an administrator to merge/combine records w/o losing the data? Better yet, w/o duplicating the data after the data has been merged?
Thanks for your help!