I do have this acr object in my application account record type one is practioner and other account record type is clinic Contact record type is individual With practioner account type direct relation and for clinc record type indriect
Select Id, Name,role From Account Where role=‘ITP’ AND Id IN (Select AccountId From Contact) @samarth ahuja is this query correct please make correction if it is wrong
That's great thanks for sharing
Question to solve at 2:46
I do have this acr object in my application account record type one is practioner and other account record type is clinic
Contact record type is individual
With practioner account type direct relation and for clinc record type indriect
why don't I have access to "contacts to multiple accounts"? All I see is general settings.
Select Id, Name,role From Account Where role=‘ITP’ AND Id IN (Select AccountId From Contact)
@samarth ahuja is this query correct please make correction if it is wrong
SELECT Id, Name FROM Contact WHERE Role='ITP' AND Id IN (SELECT ContactId FROM AccountContactRelation WHERE AccountId = )