Drop down lists

[shawnj985]

Hello all

I have a Contact table with at least 3 fields (first, middle and last names) and a field called "Fullname" that concantenates my other 3 fields. i.e. John C. Smith

I would like to have a layout in another table with at least one field called Full Name that has a drop down button which I would like to list all data from the Fullname field in my Contacts table. Once I select a record from this list, it will populate that Fullname field.

I know this may be easy to some, but I can't get it for now.

[LaRetta]

Attached is an example. :wink2:

Shawn985.zip