Custom Display field

I'm using a custom display field as for a lookup table. I'm sure this is something simple but I can't figure it out.
I created a view with 2 tables;

• Hotel Name
  
• hotel contact
  

SQL Query

SELECT

hotelleadcontact.ID,

hotelleadcontact.HotelContactID,

hotelleadcontact.LeadID,

hotels.Hotel Name,

hotel contacts.First Name,

hotel contacts.Last Name,

hotel contacts.E-mail Address,

hotel contacts.Job Title,

hotel contacts.Business Phone,

hotel contacts.Home Phone,

hotel contacts.Mobile Phone,

hotel contacts.Fax Number

FROM hotelleadcontact

INNER JOIN hotel contacts ON hotelleadcontact.HotelContactID = hotel contacts.ID

INNER JOIN hotels ON hotel contacts.Company_ID = hotels.ID

ORDER BY hotel contacts.First Name
I want to lookup the hotel contact name & surname but also display the hotels.Hotel Name in the lookup table. I've created a custom lookup display field to include first name and surname but not sure how to include Hotel Name to the display field;

concat(First Name, ' ',Last Name)
A problem im having with the dispaly field above is that some of the hotel names is not visible. If I select the blank space it includes the hotel contact anyway. If I only use First Name all the records are visible, very confusing