+ Start a Discussion
Mayank_JoshiMayank_Joshi 

Lookup Filter Criteria

Hi ,

I am working on requirement using Many to many relationship ,where I need to update Records under RL of Opptunity(Standard master) from Junction Object .

** Opportunity(Standard Master) >> Opportunity Product Model(Detail/Junction)>>(Master)Platform Model

** Platform Master(Master) >> Platform Model(Detail) 

Based on Platform Master's record on opportunity , i need to make lookup filter on Opptunity Platform Model .So that only Child(Platform Model ) of Platform Master will return through Lookup Filter .

Below is the search criteria :

Platform Model Selected: Platform Master: Platform Name CONTAINS Platform Model Selected: Opportunity: Platform(Formula Field) 

But ,it is showing all records also it is woking with START WITH .But not with EQUAL Operator .

Can we achieve this functionality using Lookup Filters ? 

Thanks,
Mayank Joshi 
 
Mayank_JoshiMayank_Joshi

Can any body suggest something ?

sivaextsivaext

Hi 

 

In Opportunity 

 

The lookup filter like this

 

Opportunity.PlatformMaster.name   equals platformModel.name