Drop Down Selection - Once item is selected - Populate field to the right.

[meppley7]

I am trying to do the following. I understand how to create relationships.

However, when I create a field with a drop down selection (in this example Phone Number and Email) once that list item is selected I would like the column to the right to populate that information.



So when Phone # is selected, the field to the right will populate a number for this individual.

Thanks for the help.

[June7]

What is the structure of the Phone & Email table? What is the relationship to Contact ID table? Have you looked at the Access Contacts database template?

BTW, advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention.

[meppley7]

Ok thanks for the help.