dlookup in access?

[ashleywanless]

Hi i have two tables, firstly business area tbl contains an ID, description and email field, secondly initiatives table holds business area description and business email. When the user enters the business area description from the dropdown lookup in the initiatives input form i want the email field to pre populate based on the email in the business area table email field.

Can this be done on my tables or only on my form?

Thanks