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.
The name of the table from which the values will be retrieved.
A possible SQL string to filter the values to be recovered.
The links between the recovery table and the destination table are managed.
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.
After the first selection from the main table, it is possible to set a second selection associated with the values of the first.
A SQL string to filter the values to be retrieved on the secondary table.
The links that will be made from the secondary table to the destination table.