Combine 2 Fields into One

[Matt Leach]

I'm sure there is a way to do this but i am drawing a blank.

I have a database that contains a Customer Table and Orders Table.

On th customers table i have one field for first name, and one field for last name. I also have a button the create a new order that copies over some information about the customer to the orders table.

On the Orders table, there is a field for Full Name (not separated as the customers table). Is there a way to copy the first and last name from the customers table first and last name fields and add it to the orders table in the full name field?

I know i could wok around this by separating the fields on the orders table but for some reason this is the way the customer wants it.

[mr_vodka]

Your orders table should use a lookup from the customers table. You can use a calc to concatenate the full name: FName & " " & LName

[Matt Leach]

I received a message from Lee Smith with the following calculation that worked:

FullName (calculation, Text Result) =

First Name & " " & Last Name

Thanks for the help, starting to get the hang of how these calculations are constructed.

[Lee Smith]

LOL

You must be following this with Email, as I removed my response immediately after it posted, because mr_vodka respones beat mine, with basically the same suggestion.

Lee