I have created a value list from another file that show the values from two seperate files (example Firstname, Lastname) I now would like to choose that combo to be enter into my new field. It looks like it will work, but I pick the name, but it only uses the first part (example: John smith shows up in the value list but when I pick it its only puts the John, into the field.) How can I get both parts?

RET

Create a new field called firstlast, make it a calculation. Enter: "firstname & " " & lastname"

Use that field as your value list.