DB relationships in Microsoft CRM 2011

mihaisz
mihaisz used Ask the Experts™
on
Is there an easier way for tracking down the relationships between tables in MS CRM 2011 than using the ER diagram from http://www.microsoft.com/en-us/download/details.aspx?id=2640?

More particularly, I entered a note for a Contact and I need to build a Select that shows me the note and the Contact’s name.
So I have to go from dbo.Annotation to dbo.Contact.

I also tried View Dependencies from SQL Management studio but it only shows me BusinessUnitBase and OwnerBase.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mark WillsTopic Advisor, Page Editor
Distinguished Expert 2018
Commented:
Yeah, it is a pain in the proverbial but "they" all say use those ER diagrams.

It has been quite some time since playing with CRM at a DB level, but thought I would chime in anyway...

There is a bit more help out there...

Have a look at the reporting modules and the "Filtered" views (filtered taking into consideration the permissions you have to actually see the data) : http://msdn.microsoft.com/en-us/library/cc308184.aspx And following that through... I have linked to the "customer" filtered views : http://msdn.microsoft.com/en-us/library/dd548500.aspx

Look for "Report Writing" as a general guide - found more help that way than trying to unravel the actual database. Having said that, once you get into the actual DB and have a look at the views (the views also exist without the "filtered" prefix)

http://msdn.microsoft.com/en-us/library/cc308174.aspx

Hope that helps a bit...

p.s. there is a wiki which might help : http://social.technet.microsoft.com/wiki/contents/articles/2490.microsoft-dynamics-crm-2011-development-resources-en-us.aspx
Chief Technology Ninja
Distinguished Expert 2018
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial