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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Active Discussion

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

  • SS-01100907-0 Profile Picture
    Microsoft Employee on at

    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.

  • shennu Profile Picture
    702 on at

    Thanks Soumen!

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

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
Subra Profile Picture

Subra 152

#2
11manish Profile Picture

11manish 112

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 86 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans