You need to sign in to do that
Don't have an account?
Lookup Relationship, Lookup Dialog & "Select distinct"
I have a question pertaining to Lookup relationships and Lookup Dialogs. I have provided an example of the table/object structure below and the scenario.
A) GEO Object: (3 fields)
GEO Name GEOID Country
APAC 1000 Singapore
APAC 1500 Japan
EMEA 2000 UK
EMEA 2500 France
AMER 5000 Americas
B) Incentive Object: (2 fields – the GEO field on this object is a lookup of the GEO Name on the GEO Object)
Incentive Name GEO
IncABC APAC
IncDEF EMEA
Scenario:I would like to click on the “look up” icon on the Incentive Object on the GEO field, and see a list of values from the GEO Object in the Lookup Dialog. However, I would only like to see 3 values (APAC, EMEA, AMER) instead of all 5 entries (APAC, APAC, EMEA, EMEA, AMER). Essentially performing a “select distinct” type lookup on a field in the GEO object.
Is this possible? If yes, how can this be achieved. I’ve read about the lookup filters but it is in beta and I’m not really sure if this can solve the problem of managing a “select distinct” type filter.
Thanks in advance.