Create a view with N-N relationship as creteria

(0) Share

Report

Posted on by Community Member

Hello all,

I have two entites : User and Event, in which Event is a new entity. for presenting the internal attendees of the event, I created a N-N relationship between them.

How can I create a view : The events that I attended, which means the list of events in which the actual user has attended?

I did the test, while the N-N relationship can not be the creteria of an advanced search. In the other case, may I create a button to display the associated view, or a web page, or a reporting?

Thank you all in advance for your ideas.

Chao ZHENG

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Community Member on at

Like (0)

Report

Hi,

NxN relationships stores in an other table not an entity

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Erman,

Yes, I know that when we create a N-N relationship, there will be an intermedia table created automatically in the database, but this table is not manipulable in the interface of Dynamics CRM.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

"The events that I attended, which means the list of events in which the actual user has attended?"

Via advanced find

Look for Events

Just leave "select" as it is and from the second "select", in the list of related items select user and then select "Equals current user".

You can define the same filter criteria when creating a system view in the Event entity

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Sven. But what you said is in the situation of having a lookup field in Event. Now the problem is the relationship type is N-N. There's no referential field that I can choose as criteria.

Thank you all the same.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

But with many to many you don't have a lookup?

You will just see the relationship in the left hand menu

Was this reply helpful? Yes No
Verified answer

MDoddio73 1,910 on at

Like (0)

Report

Hey,

Are you using CRM 4.0 or CRM 2011? In CRM 4.0, I don't think it's possible to join M:M relationships Using the Advanced Find.

However, if you're using CRM 2011, it's fairly simple:

1.) In the Look for: picklist, select the Event entity.

2.) In the first column of your query, scroll down to the "Related" section and select User. This will create a new section below called "Users".

3.) In the Users section, select User field.

4.) The next column, you can either select "Equals" (if you just want to hard code your User account into the query) or "Equals Current User" (if you want to allow others to run this query). If you choose the latter, your done, and ready to execute the query. If you choose the former...

5.) In the Enter Value type in part of your name (and let the auto-resolve complete it for you) and hit the Tab key.

You results should include all the Events to which you've been associated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That's exactly the same as what I said two posts above :-)

Was this reply helpful? Yes No
MDoddio73 1,910 on at

Like (0)

Report

D'oh!

Sorry. In my haste to answer, I didn't scroll down the entire thread, I wrote my answer right under the original post.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hehe no problem, happened to me as well before :)

I hope that this solution will help with Chao's issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Sven, hello MDoddio73,

Thank you for all your answers. In fact I am in CRM 4.0, that's why I did not find the expected field as Sven said.

I have developed a ISV.Config button on the Event view to show the attended events view.

In CRM 2011, that improves a lot.

Thank you all.

Chao

Was this reply helpful? Yes No

Community site session details

Create a view with N-N relationship as creteria

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Create a view with N-N relationship as creteria

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates