Microsoft Dynamics 365

STEP 1: Create data entity for the header and line table (set the same field as primary key for both tables).             The following data entity, staging table and security is created automatically. STEP 2: Create RowID(integer)   and parent row id (integer) in the header staging table (where the Execution Id and Definition group field, relation, index are automatically created).           STEP 3: Create row id and parent row id fields, create relation for primary key, definition group, execution id.           STEP 4: Create relation in line level data entity (primary key) STEP 5: Create composite data entity By adding new dataset element for header and line entity, then map the relation in the line entity. STEP 6: Front end à Workspaces à Data management In data entities, create new record and enter the   composite entity