Recent content by confusimo

Thanks so much for the help - this is exactly what I did in the end, kinda annoying to have to move it to a new table to create the new ID's - but much easier than any other way I'd imagined. Thanks again and sorry for the late reply!

I have a set of databases each with a table with one-to-many relationships to two other tables. I want to merge the tables from one database into another, but the primary keys start at 1 for each database - and so the keys conflict when merged into one unified table. Is there any way I can...