merging tables

icemonster

Registered User.
Local time
Today, 00:43
Joined
Jan 30, 2010
Messages
502
i know i've asked this already and sorry for posting again. but i read an article that tackles this, but somehow i have trouble following it

the link is this:

http://www.databasejournal.com/features/msaccess/article.php/2236471/How-to-Merge-Records-from-Two-Identical-Access-Databases.htm

and my question is, i ahve a third table that has a PK, and two FK, from the first two tables respectively, how do i change it too? is there a way to add value to an autonumber like, if the set is 123, i just update it to become 223, is it possible?
 
I don't think I read your previous question, but to me your topic 'merging tables' implies you want to merge two like tables, that article explains the complications of merging two databases with many tables. Is that what your trying to do or is it a 'simple' merge of two tables?
 

Users who are viewing this thread

Back
Top Bottom