Updating Field When Inputting Into Another????

Hi there

I have a database that has two tables.

Table 1 is called applications and table 2 is called contacts.

Table 1 has two fields that relate (not through the relationships) to table 2.

These fields are named thus: Officer and ContactTelephone

Through a form I wish to be able to do the following.

When I choose the Officer from the drop down box (combo box tied into Table2) it will then automatically put in to ContactTelephone the necesary number.

It MUST drag the info from Table 2 and place in to Table 1.

Any ideas :confused:

Thanks :D

Jools