locked
Design question RRS feed

  • Question

  • I have a custom entity called "Survey" which has 200 attributes ( 200 questions).

    I need to report by category ( there are about 20 categories).

    For example:  Questions 1-20 belong to category A.  Questions 21-50 to Category B.  Question 51, 61, 71 to Category C. 

    How do I model it in CRM 2011? 

    I am thinking of having 2 entities ( Category and Question), set 1:N relationship between Category and Question.  Finally set 1:N relationship between Survey and Question.

    Will I be able to report survey with their questions by category?

    Any suggestions will be greatly appreciated.   

    Friday, February 22, 2013 10:17 PM

Answers

  • Every Question belongs to a category. So you'll have categories as entity. C You'll also have a Questions Q entity with a lookup to C to assign 1 Category to each new Q record. Finally you'll have your surveys S where mutiple Qs can be assigned with. Should be N:M If you're designing your Report you can filter by C or by Qs assigned to S. Hope this helps

    Carsten Groth http://carstengroth.wordpress.com Microsoft Dynamics Certified Technology Specialist, MVP für Microsoft Dynamics CRM

    • Marked as answer by Yukimo Friday, February 22, 2013 11:46 PM
    Friday, February 22, 2013 10:46 PM