Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM2011 - Advanced Find with N:N Relationship RRS feed

 > 

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Unfortunately this approach doesn't work for N:N relationships because the second join is only from the intersect entity rather than the 'Entity' record. This approach only works for 1:N relationships.

    Hope this helps,

    Scot

    Scott Durow
    Blog www.develop1.net    Follow Me
    Rockstar365
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Tuesday, January 7, 2014 3:54 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Your advanced find looks wrong.

    What you are doing is your are searching for:

    Entities that has and initiative value, which has an entity, which in turn has a value B...

    This is wrong.

    If you just want to find entities with either Value a or value B.. just deleted everything from the first blue row called Entities.. and then add value b to the value a, which will make it search for either value.

    Rune Daub Senior Consultant - Dynateam CRM http://www.xrmmanagement.com

    • Proposed as answer by RuneDaub Tuesday, January 7, 2014 3:56 PM
    • Unproposed as answer by n1k_f Tuesday, January 7, 2014 5:03 PM
    • Marked as answer by n1k_f Tuesday, January 7, 2014 5:03 PM
    Tuesday, January 7, 2014 3:56 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Unfortunately this approach doesn't work for N:N relationships because the second join is only from the intersect entity rather than the 'Entity' record. This approach only works for 1:N relationships.

    Hope this helps,

    Scot

    Scott Durow
    Blog www.develop1.net    Follow Me
    Rockstar365
    If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"

    Tuesday, January 7, 2014 3:54 PM
    Answerer
  • Question
    Sign in to vote
    0
    Sign in to vote

    Your advanced find looks wrong.

    What you are doing is your are searching for:

    Entities that has and initiative value, which has an entity, which in turn has a value B...

    This is wrong.

    If you just want to find entities with either Value a or value B.. just deleted everything from the first blue row called Entities.. and then add value b to the value a, which will make it search for either value.

    Rune Daub Senior Consultant - Dynateam CRM http://www.xrmmanagement.com

    • Proposed as answer by RuneDaub Tuesday, January 7, 2014 3:56 PM
    • Unproposed as answer by n1k_f Tuesday, January 7, 2014 5:03 PM
    • Marked as answer by n1k_f Tuesday, January 7, 2014 5:03 PM
    Tuesday, January 7, 2014 3:56 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello - thanks for the replies. It seems unfortunate that we can not have an advanced query function on an N:N relationship to find accounts matching both intiatives. Assuming an SSRS report is the way to go.

    Thanks again!

    Nick

    Tuesday, January 7, 2014 5:05 PM