Sorry - I think I have already posted this question in the incorrect area on the forum.

My question is:

I have 2 forms -

Form 1 - 'Memorial Branch Details'

Fields:        - Branch Name

                  - Email address

                 - Telephone number

Form 2 - 'Warehouse list'

In this form I want to have a drop down list which contains the various 'Branch Names' from Form 1.

Once the 'Branch Name' has been selected, I would like a text box in Form 2 to auto fill the corresponding branch email address in.

What is the best way to do this?

Many thanks

Tom