Relationship Types in Tables

Rumman Ansari   Software Engineer   2024-05-30 04:55:13   151  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

Table of Content:

Relationship Types Selected
Figure: Relationship Types in D365 F&O

  1. NotSpecified
  2. Association
  3. Composition
  4. Link
  5. Specialization
  6. Aggregation

Specify the type of relationship: 

NotSpecified -The system infers the value from the following sequence: Specialization, Link, Composition, Aggregation, Association. 

Specialization - Applies only to table inheritance. 

Link - Used in migration tools to support earlier versions. You should not use Link as a relationship type. 

Composition - Use if the current relation only exists once. It could be a specific pallet in a warehouse. 

Aggregation - Use if the parent table has a delete action defined to be used in the current relation. 

Association - Standard foreign key relation.