Lead your team forward
OCT 24 / 9AM ET Register nowHow to Create an MN Relationship in RDM
MN relationships in RDM are not defined in the RDM Logical Model > Relationships node. Instead, this type of a relationship is implemented via a MNREFERENCES domain type assigned to a child table.
To create an MN relationship:
-
Create a domain as described in Domains, with the Type attribute set to
MNREFERENCES
and Foreign key table attribute set to the parent table. -
Optionally, set a Validation message.
-
Assign the created domain to the related column in the child table (RDM Logical Model > Tables > [Table] (double-click) > Columns tab).
-
Go to the parent table and switch to the Validations tab.
-
In the Unique Keys section, add a new unique key with an arbitrary name and add a column from which the data will be read to the child table.
-
Check the Primary key.
Was this page useful?