I understand the single value, I guess what is frustrating is a template I downloaded had this ability to pull data from 2 fields and place in 1 field and i can't figure out how they did it. The template did not fit my needs so I kind of used it as a guide to design my own, maybe the solution to my problem is finding another way to bring in the data from 2 fields and posting in one single field in a table?

I am building an employee database in access 2007, I have put employee names, identified with an ID, the fields are identified as first name and last name 2 seperate fields. Question is this... When creating a lookup Column in a form or other table the names show up in two columns which is fine but when a name is selected only the first name or last name appears not both? I am a beginner with access but am quickly grasping the concept and see this...