One Child Instance Associated with Many Parent Instances

This topic provides details about one child record instance associated with many parent record instances. For a general overview of the one parent record type to one child record type relationship, see One Parent Record Type to One Child Record Type.

This topic provides details about one child record instance associated with many parent record instances. For a general overview of the one parent record type to one child record type relationship, see One Parent Record Type to One Child Record Type.

The one child instance associated with many parent instances scenario has the same relationship as the one parent instance associated with many child instances scenario. There's one parent record type and one child record type. However, the relationship between instances is unique. Usually, one parent instance associates with one or more child instances. The parent record has a sublist where each row in the list shows a specific associated child record instance.

On the child record instance, there's a link to the parent record instance. An example, illustrated by the Equipment field with Record is Parent box checked, is shown in the Parent-Child Record Relationships topic diagram.

In the less common one-to-many scenario, you associate the same child record instance with multiple parent record instances of the same record type. In other words, many parent record instances associate with the same child record instance. The individual parent record instances have sublists showing the associated child record instance. On the child record instance there's a multi-select field in which many parent records are listed.

You create this type of relationship by checking Record is Parent on the custom field and selecting a field type of Multiple Select instead of List/Record.

Related Topics

General Notices