Get Data from other fields like an Autofill

[bibbydude]

I am brand new to this program. I have two tables one with staff name and email, then another table with events they are attending. i have a drop down box on the event table to chose the person attending the event. i want this to get their email from the other table so then i can create an email to them telling them. i only want it to display their name in the field, possibly having another next to it that autofills with their email.

how do i go about doing this?

[Fitch]

Staff table should have an ID field that is an auto-entered serial number.

Events table should have a Staff ID field (not auto-entry).

Make a relationship using those fields.

Other fields in Events can now auto-enter based on the relationship.

Another option is to simply display the related info on the Event layout.