Understanding Normal Table Relations in D365 F&O - Key Concepts and Examples

Rumman Ansari   Software Engineer   2024-12-14 09:57:05   781  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

Table of Content:

What is the Normal relation in d365?

A normal relation is used to specify a relationship without any conditions. A normal relation specifies related fields in another table. Multiple fields can also be added in normal relations.

Condition is, Table 2.Field = Table1.Field

where Table1 is the parent Table and Table2 is the child table.

Setting Up an Automatic Lookup

One of the great things about a Lookup method in D365 forms is that we do not need to write code for them to be shown. In most cases, we only need to setup the relations on the table, and set what fields we want to be shown in the Auto Lookup property on the table. The system will then generate the lookup form for us. Let’s walk through an example.

In my example, I have a vehicle table. The table contains a unique identifier ‘ Vehicle ID’. But it also allows the user to select a Make and a Model for the vehicle.

When selecting the Make or the Model, I want the user to only be able to select a Make ID or Model ID that is already setup in the related form and table. I do not want the user to be able to type in whatever they want. This way, I can store additional information on the Make and Model tables, that I do not have to duplicate on this vehicle table.

In order for the lookup to show, all I need to do is two things.

  • Setup a relation between my vehicle table, and the related make and model tables.
  • Populate the AutoLookup nodes on the related Make and Model tables with the columns I want the lookup form to show.

Practical Example

Parent Table Child Table

Just Drag and drop All fields on AutoLookup FieldGroup .

Normal Table Relations in D365 - Parent

Just Drag and drop All fields on AutoLookup FieldGroup .

Normal Table Relations in D365 in Parent

Create new Relation

Normal Table Relations in D365 - Parent Table
  • Give properties of Related table.
  • Give Relation Name.

Cardinality : is the property that explains about nature of the relationship between two tables on the related table.

ZeroMore: You will select this, provided the child Table/related table can either have no record or have more related record.

ExacltlyOne : which shows the Cardinality of the related table, which means table Child table refers Parent Table. so in the table Parent Table, exacltly one record should exist agains multiple record in the child table.

Normal Table Relations in D365

  • Now create a normal relation by right clicking on the relation that you have created on above step.

Normal Table Relations in D365 Normal Table Relations in D365 -child

Now select all related properties so that it will be look like below.

Normal Table Relations in D365 - Child

Output

Normal Table Relations in D365
Figure:

Uses and Benefits of Normal Table Relations in D365

In Microsoft Dynamics 365, Normal Table Relations are used to define how tables are related to each other in a database. This is important because it allows users to access data from multiple tables without having to manually join them together. Here are some of the key uses of Normal Table Relations in D365:

  1. Simplify data access: Normal Table Relations make it easy to access data from multiple tables at once. Users can simply select the related tables and D365 will automatically join them together based on the defined relationship.

  2. Data consistency: Normal Table Relations ensure that data is consistent across related tables. For example, if you have a customer table and an order table, the relationship between them can be defined so that only valid customers can be associated with orders.

  3. Efficient data retrieval: Normal Table Relations can also improve the performance of data retrieval operations. By joining related tables together, D365 can retrieve the required data in a more efficient manner than if each table was queried separately.

  4. Data integrity: Normal Table Relations help ensure data integrity by enforcing referential integrity rules. This means that if a record in a related table is deleted or modified, D365 will automatically update or delete any related records to maintain consistency.

  5. Easier maintenance: Normal Table Relations make it easier to maintain a database over time. If you need to make changes to the structure of your database, you can do so without affecting the relationships between tables.

Overall, Normal Table Relations are a key feature of D365 that enable users to work with data more efficiently and effectively. By defining relationships between tables, users can access and manipulate data in a way that is both intuitive and efficient.