For example, if a Look Up field is to select a Device Code field from the Devices table .  But the Code field is meaningless.  

I would like to view multiple fields from the Device list, say a friendly "Name" field and perhaps a "Room" field when we select a device, we want to store only the Code field in the Look Up field.

Hopefully that makes sense?