Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to set relationship which include a parameter RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    I have a list of users and a list of (let say) sports. I'd like to connect those two entities AND add a parameter which says how skilled is the user regarding this sport (0..99, 99 is the best). For example:
    John - football - 50
    John - swimming - 80
    Peter - football - 70

    In the database point of view it's simple:
    table USER: userId, ...
    table SPORT: sportId, ...
    table USER_SPORT_CONN: userId, sportId, skillLevel

    But how to do it in CRM? Are 2 entities enough? I expect I should use a relationship, but I don't know how to add there the parameter.

    Thanks for any advice!
    Jan

    Thursday, September 24, 2009 9:03 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Jan.

    Solution for your task is following:
    1. Create some custom entity (for example UserSport).
    2. Add skill field to this entity.
    3. Create relationship between UserSport entity and User entity where UserSport is child entity.
    4. Create relationship between UserSport entity and Sport entity where UserSport is child entity.
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Thursday, September 24, 2009 9:08 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Jan.

    Solution for your task is following:
    1. Create some custom entity (for example UserSport).
    2. Add skill field to this entity.
    3. Create relationship between UserSport entity and User entity where UserSport is child entity.
    4. Create relationship between UserSport entity and Sport entity where UserSport is child entity.
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Thursday, September 24, 2009 9:08 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    So - I've to create one more entity (UserSport), similarily to the database point of view I mentioned.
    Ok, thanks for fast reply!!
    Jan
    Thursday, September 24, 2009 9:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You might be able to simply add a skill field picklist to the UserSport entity and then when you create a UserSport for each user, just select the sport from the picklist and the skillset from the picklist unless you need to see the two distinct related records for some reason.
    Best Regards, Donna
    Thursday, September 24, 2009 9:51 AM