Getting data from more then one source

[Unimatrix]

In my contacts datababse I have a main table where all the is stored for my contacts.

I have a form that I use to enter and display the information from, Because I have more the one contact at a given company I have created a seperate table that contains all of the contact details for each office.

What I would like to be able to do is when I select a office on my form Access will populate the the rest of the fields in this section with the relevant information.

How do you do this?

 

[NoFrills]

Ex?

Office:

Acme Corp.
1 Main Street
New York, NY 10029
(212) 123-4567


Contacts:

John Doe...... (All his Info)
Jane Doe...... (All her info)
John Smith.....(All his info)


Something like this. And if you select a diffect office, it will have possible new contacts?


A subform and a relationship should do the trick.

 

[Unimatrix]

Thanks for the info!!!

I will give it a try