Pulling contacts from two tables into a third contact table

[intern]

Ok, I have 3 tables. One lists a contact in conjunction with the branch of the company and the trips that contact takes. The second lists a contact in conjunction with the branch of the company and which team they work with (may work with many). The third should list their email address and their phone number. Is it possible to pull the contact name and branch of company from tables 1 and 2 into 3 automatically, such that all I have to input into table 3 is additional contact information? If that is possible, is it also possible to only pull each contact/branch of company pairing once (I don't want four entries for Joe Shmoe/Sales, even if he's taken 4 trips)?


Table 1

Branch of Company	Trip Dates	Trip Location	Contact
Sales	4/1/14-4/12/14	Chicago	Joe Shmoe
HR	6/2/13-6/4/13	New York	Jane Doe

Table 2

Branch of Company	Company Team	Contact
Sales	Blue Devils	John Deere
Sales	Jets	John Deere
Sales	Jets	Joe Shmoe
HR	Sharks	Jane Doe

Table 3

Contact	Branch of Company	Email	Phone
Jane Doe	HR	jane.doe@company.com	800-555-1234
Joe Shmoe	Sales	joe.shmoe@company.com	800-555-1235
John Deere	Sales	john.deere@company.com	800-555-1236

Thanks for any help you can offer!

[burrina]

Why do you need a 3rd table and not simply use a query to get your results and then enter your data on a form? Possibly a junction table is what you really need?

[intern]

I'm teaching myself database, so I'm afraid I'm not really sure what a junction table is...

[burrina]

I can't really help you without seeing what you have. Start doing some research on Access. Use Google and Help.

[intern]

Thanks so much! I did some research on junction tables, and even if that's not what I'm doing, it led me to some helpful work-arounds. I think I've got it!