Systems Engineering and RDBMS

  • Click Here for Decipher's Homepage


  • Categories

  • Questions?

    Please send your wish list of things that you would like us to write about or if you have suggestions to help improve this blog site. You can send all questions/suggestions to: Blog Support
  • Archives

  • Blog Stats

    • 7,363,950 Views

MS Dynamics CRM v4: Many to Many Relationships Limitations

Posted by decipherinfosys on September 23, 2008

Even though Microsoft added M:N (Many to Many) relationship support to their CRM product, there are still a lot of issues with it. Some of the things that you need to keep in mind:

1) If you let MS Dynamics create the intersection table between the two custom entities which are in an M:N relationship, then there is no way for you to add any other attributes to that intersection table. This intersection table will have the GUID columns from the two parent tables and an additional GUID column for the intersection table itself.

2) The intersection table created by MS Dynamics does not support workflow. What this means is that one cannot fire off workflows when a record gets created that ties up those entities.

So, how can you get around those limitations? Well, a M:N relationship between two entities gets resolved by creating an intersection table. Rather than letting MS Dynamics create it for, you should create a table yourself and then define two N:1 relationships with the parent tables. That way, you can by pass both the issues that are mentioned above.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: