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.