table relations development extension practices recap in Microsoft Dynamics 365 Finance and Operations apps

table relations development extension practices recap in Microsoft Dynamics 365 Finance and Operations apps

A relationship is created between tables with related data

In addition to associating rows in one table with another, relations (using cardinality) can also be used to restrict the rows returned in a table and enforce referential integrity. 

• Defined between tables with related data to associate rows
• Relations are set on relations node beneath a table element
• Useful for performing lookups for forms
• Also used to restrict data retrieval
• Creating auto joins in Queries and forms
• Enforce referential integrity

Relationship type:

• Normal
  • Normal is used for navigational purpose only and no integrity check.
    A normal relation is used to specify a relation without any conditions. In the field property, we select the field in the primary table that relates to a field in the present table. In the related field property, we would then select a field in the related table.
• Foreign key

  • Used to specify a correspondence between a foreign key field in the present table to the primary key field in another parent table.
    Foreign key relations are usually set on a child table. We often refer to a child table as a table that has the foreign key.

    Foreign key is helpful for navigational purpose as well as referential integrity.

• (Conditional) Field fixed

  • A field fixed relation is a relation that's used to restrict records in the primary table. There's a field property which allows us to choose which field in the primary table we want to use to restrict the records. There's also a value property where we enter the value of a selected field to act as a filter. This relates only records in the primary table that match the field value.

    Only numeric values can be entered in the value property.

• (Conditional) Related field fixed
  • A related field fixed relation is very similar to a field fixed relation except for it's used to specify the relation of the fields and restrict records in a related table instead of the primary table. The same properties are used in set as in a field fixed relation. We can only set a related field fixed relation on a numeric field