Trying to create a relational database.

Trying to create a relational database.

I can't figure out how to create the following database (it is a basic address book):

The Person form has the following fields:
ID,
First Name,
Middle Initial,
Last Name,


I have created an "Address" form.

The Address form allows me to associate multiple addresses for a single person.

I added a field to this Address form, called "Belongs To" of type "Import Data From [Person Form] - ID" as a Single Select list.

The problem is that, in the Address form, the "Belongs To" dropdown only displays the ID field which is fairly meaningless (except as a foreign key association).

What I need is for the "Belongs To" selection to be assigned to the ID of the correct person, but the dropdown list should not show IDs. Instead it should show "<First Name> <Last Name>" in the dropdown. Or, better yet, I would like to use a custom View from which to select. the appropriate person.

Is this possible?

Thanks,
Fernando
fernando