Related tables

Navigation:  Attribute Properties >

Related tables

Previous pageReturn to chapter overviewNext page

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

parent_table

 

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_for_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.

tree_view_child_add_record3