Problem designing a table that pull data from lookup on another ta

Hi, i'm not too familar with Access so please help me out here
i have
table 1 with Customer ID + address1
where
table 2 with Customer ID + address2

what i want to do is to create a table 3
where

column 1 will be fill by lookup list from table 1's Customer ID
i wanted to make it so when i choose from the look up list in colum 1
base on the Customer ID it will automatically fill in
colum 2 that is the Address 2 in Table 2 with the same ID

i am stuck without know how this can be done
please tell me how i can make this happen

What business need are you attempting to solve by putting the two addresses
in two different tables?

--
More info, please ...

Jeff Boyce
Access MVP

its just an example of the kind of functions i want to achieve..
i didn't designed the original table and there r applications that run
dependent on those table already so instead of reorganizing everything
i wanna see if there is an easier way to add on top.
the original Table 1 holds the customer ID with their main office address
where
table 2 holds the customer ID with all the branch offices addresses. (more
then 1 entry with each customer ID depends on how many branch offices there
is)

What i need to do is design a 3rd table for RMA department
here is the part i can't figure out how it works, i want to make
a Form to update the data on table 3, where in the form i can use the
customer ID as a lookup and it will automatically list both main address from
table 1 and branch office address from table 2 so the RMA guy will input an
RMA # then click
a button to save it all into table 3
i can't figure out how to set up the text box in the From that when user
change the customer ID (drop down list of customer ID lookup).
it will automatically update the text box showing both table 1 and table 2
address that is related to that particular customer ID.

sorry for the trouble but i'm newbie with access





"Jeff Boyce" wrote:

What business need are you attempting to solve by putting the two addresses
in two different tables?

--
More info, please ...

Jeff Boyce
Access MVP

If you already have the data existing, spread across two tables, don't
further complicate your design by extracting data and putting into a third
table. Use a query to join the data in the two tables, and display in your
form.

--
Good luck

Jeff Boyce
Access MVP