Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

One to one or one to many relationship between qouteproduct and x custom entity

(0) ShareShare
ReportReport
Posted on by

Hi , i want have one to one or one to many relationship between quoteproduct and my coustom entity but crm dont have in default , i dont know why and how can i do it ?  

*This post is locked for comments

  • RaviKashyap Profile Picture
    55,410 Moderator on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    If you have got the answer of your questions, please mark the suggestion as helpful and close the thread.

  • Community Member Profile Picture
    on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    thanks for your answer

  • Verified answer
    RaviKashyap Profile Picture
    55,410 Moderator on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    Hi Somayeh,

    From the screenshot, it looks like you are not on V9 which is why we are able to create a lookup field of order product but you are not. In previous versions, as you noticed, it was not possible to relate quote product entity.

    You can however still create a lookup field of your custom entity on Quote Product.

    Hope this helps.

  • Community Member Profile Picture
    on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    tanks Ravi , please see this pic that i attach , 

    i just add subgrid of quteproduct delivery into quote product and i dont have quote line instead of that i have quotedetail  , 

    quoteproductDetail.JPG

    quoteproductDetail.JPG

    1321.All.JPG

    thanks for your care 

  • Community Member Profile Picture
    on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

     thanks alex  , i dont have Quote Line in CRM , its quoteDetail 

    All.JPG

  • RaviKashyap Profile Picture
    55,410 Moderator on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    Not sure why but this is working for me and for Alex as well above. As I said, don't bother about relationship, directly create a field of lookup type in your custom entity. It should work.

  • Community Member Profile Picture
    on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    Thanks Ravi ,sorry i cant attach image  i try attach it , i dont know why ? But in crm 365 i have quoteproduct that is name is quotedetail not quote item i think its another entity that i dont need it    , and i can not add look up of quotedetail in each entity not custom not built in entity , and its because this entity dont let 1 to n relationship ,

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    Hi,

    You don't need to have a relationship inorder to create a field. The relationship will be created automatically when you create the field. I have tried this on my entity and it worked as expeced.

    Open you custom entity (Settings >> Customizations >> Customize the system >> {Your custom entity} >> {Custom Entity Main form} >> Within the form editor, simply clcik on "New Field", give it a name and select Lookup as the field type and then select "Quote Line". This will create a lookup field and internaly this will also create the 1:N relationship.

    It is possible that the name of the Quote Line entity is changed so you don't see that with that name. If thats teh case, check the name and use that.

    Hope this helps.

  • Community Member Profile Picture
    on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    Yes i'm sure , i dont need the quote i need quoteproduct which name is quotedetail in crm , in my custom entity i can not add lookup of quoteproduct becasue the crm in default dont have 1 to n relationship for this entity

    I could'nt attach my pic when use rich formatting im my phone

  • Community Member Profile Picture
    on at
    RE: One to one or one to many relationship between qouteproduct and x custom entity

    actually i need do it in custom entity but i hear with activity i can do this reation with field regarding but i dont no how

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans