Create one-to-many or many-to-one entity relationships overview

In Common Data Service 1:N (one-to-many) or N:1 (many-to-one) relationships define how two entities are related to each other.

Before you create a custom entity relationship, evaluate whether using an existing entity relationship would meet your requirements.
More information: Create new metadata or use existing metadata?

There are two designers you can use to create and edit 1:N (one-to-many) or N:1 (many-to-one) relationships:

Designer Description
Power Apps portal Provides an easy streamlined experience, but some special settings are not available.
More information: Create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships in Power Apps portal
Solution explorer Not as easy, but provides for more flexibility for less common requirements.
More information: Create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships using solution explorer

Note

You can also create new entity relationship in your environment using the following:

Information in this topic will help you choose which designer you can use.

You should use the Power Apps portal to create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships unless you need to address any of the following requirements:

  • Configure field mappings
  • Configure navigation pane options for model-driven app
  • Configure relationship behaviors
  • Define whether the relationship is hidden in advanced find.
  • Make a Hierarchical relationship

Community tools

Entity Relation Diagram Creator is a tool that XrmToolbox community developed for Common Data Service. Please see the Developer tools for Common Data Service topic for more community developed tools.

Note

The community tools are not a product of Microsoft and does not extend support to the community tools. If you have questions pertaining to the tool, please contact the publisher. More Information: XrmToolBox.

See also

Create and edit relationships between entities
Create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships in Power Apps portal
Create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships using solution explorer
Developer documentation: Customize entity relationship metadata
Developer documentation: Entity relationship eligibility