Updating table with data from another table

[ans]

Hi, New here, and not very advanced with Access - I need help.



I have 2 tables:
Table 1 - 6 columns
Table 2 - 2 columns

Table 1 contains different codes in each of the columns/rows of data
Table 2 contains the codes contained in Table 1 as well as a new corresponding code

I want to either update Table 1 or produce a new Table that maps the codes in the Table 1 to the corresponding new code in Table 2.

I have no trouble doing this for 1 column, but as soon as try to add another column to be updated I get into trouble.

Thanks!

[RuralGuy]

I'm not sure I completely understand your situation but you can use the query builder and have more than one copy of a table in it. Table 1 could be in there one time and table 2 could be in there 6 times if necessary.

[ans]

Perfect - thanks!

[RuralGuy]

You are most welcome. I used the Thread Tools at the top of the thread to mark this thread as Solved. It can be undone if you still have issues.