Hello, I'm VERY new to working in Access 2007, so this might be a stupid question. 
Is it possible to merge the FirstName and LastName fields from 1 table when using a multi-value lookup in a different table? If so, how?

Is it possible to merge the FirstName and LastName fields from 1 table when using a multi-value lookup in a different table? If so, how?