I’m using a looking function to get data from another table using:
Lookup(Contacts, [Text 2], [Business Name]).Firstname
That give me the firstname as the result but I would like to see surname and firstname.
I tried using the following thinking it would work but it doesn’t:
Lookup(Contacts, [Text 2], [Business Name]).Concatenate(Contacts.Surname, Contacts.Firstname)
It gives me the primary ID for that row but also the surname and firstname for all rows