Look Up Filters

Look Up Filters

Hi


How do you concatenate an input field with a look up field?  For example, when I look up a form, I only see the feeds which are direct entries in that form i.e. "Cable reference number" but not fields which are lookups from another field i.e. "Location" or "Device".  I want to see "CABLE REFERENCE - LOCATION - DEVICE"

Also, how would you then filter the concatenated field