I have a table where we have products defined something like:
Product name | Client | Other product info
In another table, we have the columns:
Products selected | Client
You select multiple products for Products selected and the Client column is a lookup.
However, the same client shows up multiple times in the Client field if more than one of their products is selected. Is there a way to show any given client a single time in the Client field?
I had hoped that using a new field, Client unique with the ARRAYUNIQUE function would do it. But ARRAYUNIQUE only seems to work on numeric arrays.
Any idea how to accomplish this?