I've just finished a draft database for storing info gathered from surveys by a number of users. The users will need their own copy of the database to enter their info and ultimately these will need merging together.
I know I could import the tables into a master database and run some append queries but I think I'm going to be ask to provide some kind of merge functionality. This is a big step for me and I have little idea where to start so any suggestions would be gratefully received.
The database comprises 1 main table and 17 child tables, linked by a textual, manually entered ID (i.e not autonumbers). Theoretically, this id will be not be duplicated in the copies of the database but I guess its not impossible, so before running any query I would need to check for the existence of the id and ask the user if they want to overwrite existing information or discard the new information.