It will probably very easy for you, but I cannot manage to solve my issue.

I want to have a field looking up in another table for an employee name, first name or company, but only showing First name and Last Name. While I want to have a second field next to it automatically filled with the name of the company from the employee chosen in the first field.

So basically, I managed to have the first field filled with the first name, Last name and company. But, I really don't know how to automatically fill the second field with only the company name.

Could you help?