HI, I'm working on a project and I need to filter a Lookup field without duplicates. I'll explain what I have in the DB:
A table named "planning" with a Primary key planID and 2 columns, "quarter" and "year" (besides another fields).
Another table name "whatever" with a column named planID which use the Lookup and is the filter (besides another fields).
The problem is the second table having multiple fields with the same quarter and year. Because of that when I use a filter in the "whatever" table, it shows multiple times "Q2, 2023".
I know explained like that it's like "Don't duplicate fields in the "planning" table" but it has also other columns and data which is unique. The project's DB is untouchable, I can only add stuff, not remove, nor modify fields.
I was wondering if it's possible to use kind of a "Distinct" or Group By option in the Filter on List Page.