sorry if i sound stupid but i have not used access before and just wanted to check how to do something before i start the DB


basically it is a client records DB and each clent is assigned to one of 6 companies so 6 addresses.

i need to be able to select one of the six and it to pull through the data for the address of the selection so i can use on a mailmerge


sorry if i have not explained well, will keep searching for an answer but any help would be thankful