Reference Fields
Reference
Create a Reference Field
-
One to one
A Table record in first table is related to only one record of second table.
Example: Country has a capital city
-
One to many
A Table record in first table is related to more than one record of second table. But second table record maps to only one entry of first table
Undb refers to this category of relationship as has many. For every has many relation defined, Undb augments belongs to relationship column in the other table automatically.
Example: Country has many Cities. (other way mapping > City belongs to Country )
-
Many to many A Table record in first table is related to more than one record of second table; second table record can also map to more than on record of first table.
EgoDB refers to this category of relationship as many to many. For every many to many relation defined between tables, EgoDB augments many to many relationship column in the other table automatically.
Example: Film has many Actors. Actor has many Films (works on many films)
Further details of relationship types can be found here.
Relationships between table records can be established by using LinkToAnotherRecord column type. Workflow details are captured below.
Adding a relationship
-
Create column.
Click on ā+ā button at end of column headers.
-
Select column type.
Select Column type as āreferenceā from the drop-down menu.
-
Update column name.
Input name in the text box provided.
-
Choose relationship table.
Select child table from drop down menu.
-
Click on āCreateā.
Updating linked records
-
Click cell open the record drawer.
Click corresponding row - cell.
-
Select from the option display.
This is multiple options.
-
Click on āConfirmā button, and saving you selected.
-
Column mapping showing āreferenceā relationship.
Sheet1 āreferenceā Sheet2.
-
Column mapping for āBelongs toā relationship [Automatically updated].
Sheet2 ābelongs toā Sheet1.