Connect dataset to parent dataset

En foreldre–barn-relasjon lager et hierarki der ett datasett (forelder) gir struktur til et annet (barn). For eksempel kan byområder (forelder) organisere parkeringsplasser (barn), der hver plass tilhører et område. I applikasjonen kan brukeren se barneposter direkte fra en foreldrespost. Slike relasjoner passer for hierarkier der barnedata avhenger av foreldredata. Her kobler vi togstasjoner (barn) til toglinjer (forelder).

14 steps

A parent-child relationship creates a hierarchy where one dataset (the parent) provides structure for another (the child). For example, a dataset of city areas (parent) can organize a dataset of parking lots (child), with each parking lot belonging to a specific city area. In the client application, users can browse all related child records directly from the detail view of a parent record.\ \ Parent-child relationships are best for hierarchical structures where child data depends on parent data. Here, we will connect a dataset of train stations (child) to a dataset of train lines (parent).

Click "Datasets"

Choose the dataset that you want to connect to a parent dataset. (In other words, you choose the child dataset.)

Note that parent-child relationships are based on a one-to-many relationship, where each child is associated with a single parent, but a parent can have multiple children. In this simple example, this requirement is met. However, if a train station could belong to more than one train line—which is likely more realistic—you would not be able to use parent-child relationships. Instead, you would treat the train line dataset as a lookup dataset, see [Connect to a lookup dataset](https://scribehow.com/shared/Connect_dataset_to_lookup_dataset__Lwdcq6d0Sy-LaC7ym714RQ)

Click "Edit".

Click "Attributes".

Ensure that your dataset includes an attribute that matches one in the parent dataset. This attribute must be of the integer data type. The attribute names can differ as long as they contain the same values. For example, the `bane_id` attribute in the train stations dataset corresponds to the primary key attribute `id` in the train line dataset. This attribute will serve as the link between your dataset and the parent dataset.

Click on the attribute.

Scroll down, and click "Connect to parent dataset".

You can use the search box to quickly find the dataset you are looking for.

Select the parent dataset.

Decide whether your attribute requires a value or can remain empty. For example, a train station under construction might not yet be linked to any train line. If you want the parent to be optional, make sure to leave the 'Required' checkbox for the attribute unchecked.

Scroll down to "Field preview" and view how your attribute will be displayed.

Close the dropdown menu.

Click "Save".

In the attribute overview, the data type for the altered attribute now shows as a reference to a parent dataset.