Look up Wizard

Hi Vivien,

Thank you for your question.

Create a query based on the table that contains the First and Last Name fields.

Add the First and Last Name fields into the query. Save the query with a name.

Click into the next available blank field name and type the following:

FullName:[FirstName]&" "&[LastName]

This will concatenate the First Name followed by a space folllowed by the Last Name when you view the results.
e.g. Simon Khan

Then go to the foreign key field in the hours table and choose Lookup Wizard. Choose the query and then select the field FullName. It will then display the Full Name rather than just displaying the FirstName.

I hope this answers your question.

Let me know.

Regards

Simon