Lookup with multiple fields

Lookup with multiple fields

Is it possible to create a lookup that displays more than one field of information,

For example if I had a table of jobs with a lookup to select a client, could the lookup display more than one field from the client table such as client_no, name, postcode.

Thanks.