Access 2007 linking fields

Hello Everyone:

I am trying to do something and I am not sure what the proper terms are so please bare with me.

I am trying to create a table and form so that one table has names in it and the next table has addresses in it, they must be in separate forms. Then I want to be able to create a third table or form or whatever I need to make it work. So that I can pick a name from a drop down box and an address for a drop down box and have then “linked” in another table or form so that if I pick either a name or address the other part of the information is filled to match what I did before? Hope this makes sense? What am I missing? I am using Access 2007

Please help?

Art W.