Access

Can someone help me….I want to have an access form that has a section for associates and associate address and when the address is entered rather than having the user retype the address the form is automatically populated with the already existing address of that associate..but the associates address if found in the database will be found in the address table which is different from the associates table..