Hello,
I have a base that has a Campaigns and Deliverables table. There is one Campaign which could have many deliverables. Each deliverable could have one owner.
We want the Campaigns table to have a lookup that shows all of the owners for the deliverables. Unfortunately, if someone has multiple deliverables they own it reports their campaign twice in the lookup column. Is there a way to dedupe or only show the owners name once versus the same name multiple times?
Thanks,
Victor