It would be extremely useful to have the ability to control whether a lookup-type field only returns unique values versus showing the full list of lookup values. For example:
Table 1: Record A Record B Record C
Table 2: Record X, Category 1, Links to Record A Record Y, Category 2, Links to Record B Record Z, Category 2, Links to Record B
If I add a Lookup field to Table 1 showing which categories are in the values linked to these records from Table 2, I get:
Table 1: Record A, Linked to Table 2: “Record X”, Category Lookup: “Category 1” Record B, Linked to Table 2: “Record Y, Record Z”, Category Lookup: “Category 2, Category 2” Record C: Linked to Table 2: “”, Category Lookup: “”
The desired behavior is that this Lookup field would show “Category 2” without the duplicate for Record B in Table 1.