Hi Oliver, I think you’d need to have a third table called Company which would be linked to the Users table, and its values would be the values currently in the Company field in the Users table
In the new Company table, you’d end up with a field that would show all the emails associated with a single company, and you could then use lookup fields to pull it over into your Clients table, does that make sense?
This would 100% work for me. Could you advise what that would look like?
I just had a quick go and created the COMPANIES table, a field linked to USERS, looking at solely at the company field. I then have a LOOKUP field in the COMPANIES table looking at email address but it only appears to pull one through currently.
I guess I’m just missing the way to show multiple email addreses (users)