Several fields on one field

[Meshack]

Hi,
I would like to have a field data type lookup data from another table but display them on this one field. ie on member information table there is a FirstName & LastName fields separately I would like another table with Member field lookup member information and pull both FirstName and LastName fields on one field. How do I go about this please?

Many Thanks
Meshack.

 

[PaulO]

From what you describe I think you need to build a QUERY that concatenates the First and Last Names with the following Expression

trim([FirstName])&" "&trim([LastName])

then use this Query in the lookup field in your table

ps Trim() just gets rid of any leading, duplicated, or trailing blanks in the resulting output, keeping the data nice and tidy