icemonster
05-18-2010, 10:09 AM
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?
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?