Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : oCGJcG75aUWjJgd9ybp8M8
Microsoft Dynamics CRM (Archived)

To Custom Entity or Not

Like (0) ShareShare
ReportReport
Posted on 22 Jun 2017 01:29:12 by

Hi All,

Hope you're having a lovely day!

My organisation has several teams and projects each with different data fields that they want to collect against accounts (organisations) and contacts. Importantly, the structure of the organisation can change drastically based upon external funding, so teams and projects can be created or ceased meaning that the needs can change drastically.

Traditionally when they had additional fields they would add them to the Contacts entity or Accounts entity (a big no-no as it means those tables grow enormously). Aside from capturing this information outside the CRM, I've been wondering if there was a way to meet this need in the CRM. The best idea I have so far is developing custom entities specifically for the the team's needs that we can hide later on (using security settings) if the team changes or project ends. From my limited understanding, it should be possible to link the custom entity to a contact or account record using a connection so we can ensure that the information is linked to the account in some way (I'd imagine it would only need to be a one-to-one relationship in most cases).

I'm open to other ideas on how to address this need if anyone has any advice?

Thanks,

Andrew J.

*This post is locked for comments

  • Verified answer
    Hari Narayanan Profile Picture
    589 on 22 Jun 2017 at 03:02:11
    RE: To Custom Entity or Not

    I would suggest to go with custom entity, unless you can re-use contact and account fields fully. Most of the projects which i have worked on use just account name and account address which would affect database size since both this entities have a lot of OOB fields. and as you mentioned drastic changes to the records and too many records are not a good option so any transaction must be kept in a seperate entity. you can relate the entities directly to account rather than a relationship (buit it entirely depends on your project specifications.

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 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,520 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,597 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete