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

Notifications

Announcements

No record found.

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 (1)
  • SS-01100907-0 Profile Picture
    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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 80

#3
Martin Dráb Profile Picture

Martin Dráb 64 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans