Thanks guys! I'm in the process of bustin' it out...

By the way, thank you for your replies so far..!

They resolved the foreign key issues? Here's what I'm talking about:

The auto-number pk's in legacy database are already taken in target database so new pk's would be assigned thus...