update or insert ???

[ThaiByThai]

hello -

I have table 1 and table 2 - both tables have the same fields however in table 1 they have state of birth, city of birth and place of birth - and table 2 have the fields but it's all blank - i would like to update or insert the state of birth, city of birth and place of birth from table 2 into table 1 using their ID numbers as a match -

so if ID 111 from table1 matches with ID from table2 update/insert city of birth, state of birth and place of birth inot table2.


thank you

 

[gemma-the-husky]

if you already have matching id's in both tables, then its UPDATE - otherwise its INSERT

but it all seems strange - why would you need the same data in two tables? And can you not just copy and paste the table?

 

[ThaiByThai]

Hi gemma-the-husky

Thanks! yes it's a bit strange how things are created but table1 is reading from one form and table2 is reading from another form - we are in the process of standarizing these forms so it's just a process so that we can update the tables with the information - before table2 did not have city of birth..etc those were recently added... but table1 had it so we just want to update the table

 

[jdraw]

Further to Dave's comments in post #2, I strongly suggest you get your structures normalized and relationships established before you get too far into Forms etc.

There are resources online that can help.

See these links.

http://www.about-access-databases.com/database-design.html
http://www.rogersaccesslibrary.com/forum/topic238.html
http://www.accessmvp.com/strive4peace/