This type of field is the most important of all. Its job is to create a link between one table and another.
This field makes it possible to select a row of values from another table and, through the links set, copy the values into the fields of the data form.
The sub-table also allows you to make two selections of linked data.
In an invoice, for example, after selecting the customer, the sub-table will show the possible shipping addresses.
The Subtable field creates an additional field within the database in order to save the GGUID reference of the selected data row.
An example: by creating the Customer field, the program will automatically create the gguid _customer field. This field is visible only if the database is opened with other programs and this reference is only for the main table.
|Main Table||The name of the table from which the values will be retrieved.|
|Main condition||A possible SQL string to filter the values to be recovered.|
|Main matches||The links between the recovery table and the destination table are managed.|
|Free Text||If checked, allows you to write free text within the field even without selecting a value.|
|Do not allow duplicates||If enabled, before saving, the program checks all the values in the table. If another record with the same field value is found, saving will be blocked.|
|Secondary table||After the first selection from the main table, it is possible to set a second selection associated with the values of the first.|
|Secondary condition||A SQL string to filter the values to be retrieved on the secondary table.|
|Secondary matches||The links that will be made from the secondary table to the destination table.|