Thread: Design for future merging
View Single Post
  #9  
Old April 23rd, 2010, 07:41 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
  
Posts: 1,451
Default Design for future merging
IMHO the best way would be to add a fixed number (unique to the source
location and larger than the total number of records) ) onto each PK at the
time of importing them into the main database.

Sincerely,

Fred