web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Pros and Cons of a 1:1 relationship vs add everything to the Account entity

(0) ShareShare
ReportReport
Posted on by 702

Should I create a new entity or simply use the Account entity 

Basically looking at the metadata, it is a type of account.

There are fields that is specific to this type of account, and it also requires a list of views just for this account type.

I know it is totally achievable to keep it just as an account type and just add a dedicate tab / views and etc. just for this type 

At the same time I also know, if I create a new custom entity with a 1:1 relationship with Account.

  • I can keep the form a lot simpler.
  • There will be less fields on the form, less views for users to work with.
  • All correspondents will be specific for this new entity instead of lost in all other correspondents regarding the general account entity.
  • I can control the user privilege by only using a security role instead of adding field security or JavaScript.
  • On the Ribbon (yes we are still using the classic web UI), user will get the new entity as the tile, quick search will not bring back other types of Account.

Someone said to me, it's better to keep all accounts together regardless of their type. So metadata will be kept in one place instead of 2 separate tables. But for me that's the whole point of splitting it into 2 tables is, for users who is only interested in the type A can go straight to entity A. but for user who is dealing with none specific type accounts can still get all info from the Account entity.

As you can see I am really in 2 minds here.

Love to hear your thoughts on this.

Many thanks in advanced

I have the same question (0)
  • shennu Profile Picture
    702 on at
    RE: Pros and Cons of a 1:1 relationship vs add everything to the Account entity

    Thanks Soumen!

    But can you see any downside of spliting it into 2 tables at all?

  • Soumen S Profile Picture
    on at
    RE: Pros and Cons of a 1:1 relationship vs add everything to the Account entity

    Hi,

    I believe 1:1 relation will be the right approach. It will help you to distribute the load on one entity, also you can overcome the number of field allowed for an entity and also you will not face SQL row size issue in log run.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
DAnny3211 Profile Picture

DAnny3211 433

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 137 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans