locked
find Opportunity linked to contact and contact linked again to contact RRS feed

  • Question

  • kindly help me in writing  query in Advance  find which will fetch the records associated in the below hierarchy

    Opportunity associated to Contact and whose Account is again contact.

    For Example :




    • Edited by chelseasadhu Friday, February 19, 2016 3:38 AM made changes
    Wednesday, February 17, 2016 2:09 PM

All replies

  • The easiest thing to do is update the account field with the account value from the contact record.  You can use a workflow to make that update to the opportunity records. 

    You are not going to be able to create the query you want in advanced find.  You could do it in SQL.


    Use the "Vote" option if the reply was helpful and "Answer" option if it answered your question. Thank you for helping others find helpful and answered posts!

    Thursday, March 3, 2016 11:28 PM