Related tables

Top  Previous  Next

DigiTerra Explorer supports to create mapping projects with related attribute tables. The use of related tables is necessary for example to collect different data from several tree species in one forest compartment, collect different data from several geological rock samples in one place etc. To do this you need a primary (parent) table and one (or more) related (child) table with one key data field in each attribute table to link the child table to the parent table.


Parent table definitions:


Parent table with three key data fields



k-tip-iconIn the parent table an integer data field type and Increment last value data field default value must be used to the key field. The Read only rule is suggested to use to any key field.


Field definitions of the key fields in the parent table

parent_table_f1   parent_table_f2   parent_table_f3


Child table definitions:


Child tables with the same key fields.

child_table1   child_table2   child_table3


k-tip-iconIn the child tables the same data field name and field type must be used as in the parent table. The only difference is the default value: Copy last value. The Read only rule is suggested to use to any key field in the child tables as well.


Field definitions of the key fields in the child tables.

child_table_1f   child_table_f2   child_table_f3


You must select the key field as a link field in each child table on the Source panel to build the relations between the parent table and its child tables.


Selected link fields of the child tables on the Source panel.

link_field_child_table_2   link_field_child_table_1   link_field_child_table_3


k-tip-iconBefore you start the data collection with the related tables set the Tree view for the displayed new record in the Settings panel > Record tab and save your mapping project as a DigiTerra  Explorer Map (.EXP) file.


Selected Tree view option on the Record tab for data collection in related tables.



Tree view mode during the data capture


The Record panel appears in Tree view after the geometry creation.

tree_view_parent_geometry   tree_view_parent


Tap on the name of the child table that marked with (Add) to add new the records in the child table.

tree_view_child_add_record   tree_view_child_add_record2


New added record in the child table.