You need to sign in to do that
Don't have an account?
Lightning look up filter
Hi All lightning Experts ,
I am facing a issue .
I have three objects let A,B and C .
A is parent of B and C .
I have created a junction object . 'JunObj' .. between B and C . On B object I have created a action button from there we can create a 'junObj' Records .
What i m trying to do is I want to select C which only associated to A object(in related list ) which is selected on B object record as parent not all the C
![User-added image](/forums/servlet/rtaImage?eid=9060G0000005c6S&feoid=Body&refid=0EM0G0000003chp)
I am facing a issue .
I have three objects let A,B and C .
A is parent of B and C .
I have created a junction object . 'JunObj' .. between B and C . On B object I have created a action button from there we can create a 'junObj' Records .
What i m trying to do is I want to select C which only associated to A object(in related list ) which is selected on B object record as parent not all the C
Did you try a Roll-Up Summary Field count_B__c (COUNT B) in the A object?
The big constraint is that the relationship between A and B must be a master-detail relationship in that case (otherwise you need a trigger).
From C, you can filter A with A.count_B__c = 0
1. Query all records in A where B is parent
2. Query all records in C where A is in the resulting records from 1.
3. Display Results from 2.