+ Start a Discussion
QMEQME 

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.

WmWm
Look up filters is the right approach!