Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
The entity has more than one relationship . Error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello. I have this type of problem.

    I want in my Contract Line form show Contract Number (lookup) field. To do this I need RelationShip N:1 with Contract. But when I do this, I get an error - The entity contract has more than one relationship to contractdetail, but only one is allowed. 

    I have one relationship with Contract , but this Type Of Behavior is System and I can't to put this field on form (as lookup).
    ; (This don't show in picklist). What I am doing wrong?

    <

     

    Monday, September 26, 2011 12:54 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    It won't let you create  the relationship as you said there is already system relationship exists and in normal business process contract line can't be attached to more than one contact.

    You are not doing anything wrong. it's a system behaviour.

    Anyway contractnumber is text field and if you want to display that on contractlines. Create a custom text field on contractline with same properties as contractnumber and then open the 1:N relationships on contract entity. click on the relationship between contract and contractlines, click on mappings and map the contractnumber field to the newly created field on the contract lines entity.

    I hope this helps.

    If this answer your question, please mark this post as answered.

    Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/

    • Proposed as answer by Amreek Singh Monday, September 26, 2011 1:18 PM
    • Edited by Amreek Singh Monday, September 26, 2011 1:18 PM
    • Marked as answer by mamyte03 Wednesday, September 28, 2011 6:21 AM
    Monday, September 26, 2011 1:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It won't be the lookup field. Microsoft does not let you display Contract lookup  field on contractline form  as they don't want you to change the contract of the contractlines. Its the same behavior on opportunity products, order product or sales lines etc.st

    Just curious what do you need this for as you cannot create contractlines outside the contract form anyway.

     

    Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/
    • Edited by Amreek Singh Monday, September 26, 2011 1:58 PM
    • Marked as answer by mamyte03 Wednesday, September 28, 2011 6:21 AM
    Monday, September 26, 2011 1:57 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    It won't let you create  the relationship as you said there is already system relationship exists and in normal business process contract line can't be attached to more than one contact.

    You are not doing anything wrong. it's a system behaviour.

    Anyway contractnumber is text field and if you want to display that on contractlines. Create a custom text field on contractline with same properties as contractnumber and then open the 1:N relationships on contract entity. click on the relationship between contract and contractlines, click on mappings and map the contractnumber field to the newly created field on the contract lines entity.

    I hope this helps.

    If this answer your question, please mark this post as answered.

    Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/

    • Proposed as answer by Amreek Singh Monday, September 26, 2011 1:18 PM
    • Edited by Amreek Singh Monday, September 26, 2011 1:18 PM
    • Marked as answer by mamyte03 Wednesday, September 28, 2011 6:21 AM
    Monday, September 26, 2011 1:17 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It won't let you create  the relationship as you said there is already system relationship exists and in normal business process contract line can't be attached to more than one contact.

    You are not doing anything wrong. it's a system behaviour.

    Anyway contractnumber is text field and if you want to display that on contractlines. Create a custom text field on contractline with same properties as contractnumber and then open the 1:N relationships on contract entity. click on the relationship between contract and contractlines, click on mappings and map the contractnumber field to the newly created field on the contract lines entity.

    I hope this helps.

    If this answer your question, please mark this post as answered.

    Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/

    But this field will not be a lookup field (or I am wrong? ) , because I want to do this - http://mscrm4ever.blogspot.com/2009/03/displaying-lookup-with-related-entity.html with it.
    Monday, September 26, 2011 1:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It won't be the lookup field. Microsoft does not let you display Contract lookup  field on contractline form  as they don't want you to change the contract of the contractlines. Its the same behavior on opportunity products, order product or sales lines etc.st

    Just curious what do you need this for as you cannot create contractlines outside the contract form anyway.

     

    Amreek singh Senior CRM Consultant CDC Praxa Sydney,Australia http://mscrmshop.blogspot.com/
    • Edited by Amreek Singh Monday, September 26, 2011 1:58 PM
    • Marked as answer by mamyte03 Wednesday, September 28, 2011 6:21 AM
    Monday, September 26, 2011 1:57 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    You may use 3rd party addon to achieve this funcitonality i.e. Stunware Lookup (http://www.stunnware.com/products/fld4/overview.htm) you can download the trial version for the addon. If you could explain your requirement then there could be an other way around.

    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Monday, September 26, 2011 2:36 PM