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

[meppley7]

Name: Untitled.jpg  Views: 12  Size: 104.1 KB  ID: 16150" class="thumbnail" style="float:CONFIG" />

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.