I have a form with a "Job ID field", a "Client" field and a "Job Title" field. The "Client" field is a Lookup field that pulls from a client database form. I made a new formula field to merge all of the information in an easy to read format for other forms.

The expression is this:

Job_ID + " - " + Client + " - " + Job_Title

But what I get is:

Job ID - XXXXXXXXXXXXXXXXXXX - Title

Instead of the Client field from the client database form I get the 19 digit ID of that entry instead. Is there a special syntax i need to use to get the "Client " field to show up? Thanks in advance.