Combined Lookup only showing one field
So, I have a table called CONTACTS that lists a bunch of people. First and last name are seperate records.
In another table, I want to display that name, First and Last in a single field via a pull down menu. I've got it working so when I select the pull down, it shows all the names in the list combined correctly. However, once I select on of the names, it only displays the first name in the field (again, after having selected a name from the list).
Any clue what I'm doing wrong?