Value list and calculation field

[rickh]

I have not posted here before but I did not see this topic anywhere else. So, please pardon the question if it has been brought up before.

I am creating a file with multiple tables. The primary key for many of the tables is a field containing the employee's id number. There is a a table which will reference the employee id from another table containg employee benefit information. I have created a field in the second table which has a pop-up list referencing a value list in the parent table. The pop-up list works correctly and retrieves all of the employee ids from the parent table. If I add a second field to the value list, such as last name, the pop-up list performs as expected retrieving all employee ids and last names in sorted order. If I change the second field to a calculated field called Name which concatenates the last name, a comma and space, and first name, the value list only retrieves the first value in the parent table with the Name field formatted correctly. I want to see the entire list of ids and names sorted in Name order. What am I doing wrong?

Thanks in advance for your help.

[mlordmactech]

Remove the space