Relationship Table

[Former Member]

Hi,

Can anyone tell about the Relationship table?

Hw can we add records to it and its benefits ?

Any Business case where we can implement this?

Regards

Nisha

[Former Member]

Hi Nisha,

Relationships table is used to define each of the different record-level relationships. Each relationship can be either bidirectional (sibling) or unidirectional (parent-child). This table is managed in the MDM Console and is not visible in the MDM Client,although the relationships between records can themselves be created and edited in Record mode.

there is a relationship cell in Data manager.

Relationships Cell

For each product-level relationship, you can link one or more records to the current record by double-clicking on the cell in the Record Detail tab to open the Relationships pop-up window.

The MDM Client has a window for adding

and removing related records for each product-level

relationship.The relationships windoe can be opened from Relationships field, which appears on the right side of the Record Detail tab.

Each product-level relationship is like a multi-valued lookup

field, in that it stores the links to one or more records.

Relationships pop-up window can only be opened if a

single record is selected in the Records grid.

When zero records are selected or more than one record is

selected in the Records grid, the Relationships field is disabled .

In the the Relationships pop-up window, you can access to the

following functions:

u2022 View related records for each product-level relationship.

u2022 Add (link) related records to the anchor record.

u2022 Remove (unlink) related records from the anchor record.

u2022 Split related sibling records into a new sibling group.

u2022 Reorder the child records of a parent/child relationship.

u2022 Change the anchor record.

u2022 Import relationship links from a text file.

u2022 Export relationship links to a text file.

To add one or more related records to a relationship:

1. click on the tab for the relationship to which you want to

add related records to make it the active tab.

2. Make sure the current table is the table that contains the records you want to add.

3. In the Records pane, select the records that you want to relate to the anchor record, either as: (1) siblings of a sibling anchor; (2) children of a parent anchor; or (3) parents of a child anchor.

4. Choose Relationships > Add to Relationship from the main menu, or drag-and-drop the records into the applicable sibling grid or nonanchor parent/child grid.

5. MDM adds the related records.

To remove one or more related records from a relationship:

1. If necessary, click on the tab for the relationship from which you want to remove related records to make it the active tab.

2. In the applicable grid, select the records you want to remove.

3. Right-click on one of the records and choose Remove from

Relationship from the context menu, or press Del, or choose

Relationships > Remove from Relationship from the main menu.

4. MDM removes the related records.

Reward if helpful.

Regards,

Vinay Yadav