- Set up a table, ManagerEmails, with at least these three fields: ManagerID (SerialNumber) ; Manager Name ; Manager Email
- Add ManagerID to your current table also and to your current layout as well.
- I don't know the name of your table, so I will call it "currentTable". Create this relationship:
CurrentTable::ManagerID = ManagerEmails::ManagerID
- Format CurrentTable::ManagerID as a drop down list or pop up menu with a value list that specifies ManagerEmails::ManagerID for field 1 and ManagerEmails::Manager Name for field 2.
- Add the ManagerEmails::Manager Email field to your layout.
- Now, when you select a manager in CurrentTable::ManagerID, the manager's email address will appear in the ManagerEmails::Manager Email field.
Note: if you already have a table of names and email addresses, there are ways to set up this value list from your existing table rather than enter manager names and email addresses in two different tables.
That worked a treat. Once again, thanks a million PhilModJunk!