Hello,
I am just starting to work with the Work Order database. I am creating a db for an Automotive Service Shop so I don't need a unit as shown in the sample database. Now, I have been able to follow everything so far but the only issue I am having is,
the customer base is just that, customer's names and not company names.
When I open my vehicle form, which is equivalent to the Location form, I want to display the customer's first and last name rather than a company name or just the customer's first or last name. I need to concatenate the two. Is this possible?
I have tried a few things and I would just be wasting time typing out what I have tried so, any suggestions please?
Thank you

---

Reply from Alex Hedley:

Have you seen String Concatenation Tip.
Just add a Field to your Query of FullName: FirstName & " " & LastName