consolidate data from two identical databases

[amd711]

"consolidate data from two identical databases"

i found this article for the previous issue

How to Merge Records from Two Identical Access Databases By Danny Lesandrini



however, there is step number "4" that i cannot exactly understand why and how?

1. Run a simple UPDATE query to add the value, lngMaxSiteA_ID, to EmployeeID for every record at Site B tblEmployee. The Cascade Updates should propagate those changes throughout your database.

1- he gave all records from site "B" database the same value for EmployeeID that is equal to the largest value in site "A" database !!. shouldn't EmployeeID be a primarykey?
i thought he would update to lngMaxSiteA_ID + row number (or a counter)



2- how to perform such query? and how to express row number in access?

[June7]

The instruction is to ADD (sum) the maximum Site A ID value to each Site B ID value. This will assure that every ID in Site B is greater than the maximum ID in Site A. Cascade update will pass this change into the foreign key fields of dependent tables.

Use the query designer to help build query. The SQL should be like:

UPDATE tblEmployees SET EmployeeID=[EmployeeID]+X;

In place of X type the maximum EmployeeID from Site A.