I have over 35 regions that each need their own database. I must maintain a master database. I did not want to deal will synchronized databases, and all regions can not access the master database anyway. Each region is required to have their own, separate data, and they will send me their data quarterly. At that time I want to append all data into my master database. My main question is this: I was going to use an auto number as the primary key for the records (there is no other unique number in this database such as a ssn number or order number). Can I use an autonumber as the primary key in all of the databases, and still be able to append the data into the master database. What if there are duplicate numbers in some of the databases? Is there another way for me to create a primary key, other than an auto number? Any suggestions will be greatly appreciated!