Custom Tables
It is possible for the user to create their own tables.
Create the table by clicking [Add directory]
Enter Primary key and Primary name if necessary. E.g. ID on the table. If Primary Key is used, it is recommended to select [Automatic assignment] as the field must be filled with Unique Key.
Lookup and Reference on Primary Key
Enter the Name of the table and at least where the table should be placed in the Menu. If [Edit lines] is checked, all lines in the table can be edited in a list.
Access group can be empty or 1, 2 or 3. I.e. similar to Custom tables access groups. Read more here.
Master. Use this Custom tables as sub-tables to a master table.
Here you set up the custom table to have a master table. For example, if you create a table that has debtor as the master table and insert the user table in the menu in the debtor table, you will only see the records that belong to the selected debtor. New records that are created will also have the debtor stamped on the record. A custom table that has "primary key" set can also be the master for other custom tables.
The report generator can also display these sub-tables in a master/detail report. Custom tables cannot be displayed in custom reports, such as invoice, order confirmations, etc.
For creating fields in the table. Tap on [Fields]. Read more about field creation.
SQL is not used yet.
Speed of search on your own tabs
The speed of a search in SQL depends on whether a field is indexed or not. The tables have an underlying SQL table for custom tables where a field - "Date" - is predefined and included in the indexing.
When creating a custom table, you can select "Default" and "Entries" in the "Type table" field. "Entries" is the table that is indexed on "MasterRow, Date".
If you have a table with data that is "Standard" and you want to switch to "Entries", you need to export your data, delete all rows, change the table type and then import your data again.
It is possible for the user to create their own tables.
Create the table by clicking [Add directory]
Enter Primary key and Primary name if necessary. E.g. ID on the table. If Primary Key is used, it is recommended to select [Automatic assignment] as the field must be filled with Unique Key.
Lookup and Reference on Primary Key
Enter the Name of the table and at least where the table should be placed in the Menu. If [Edit lines] is checked, all lines in the table can be edited in a list.
Access group can be empty or 1, 2 or 3. I.e. similar to Custom tables access groups. Read more here.
Master. Use this Custom tables as sub-tables to a master table.
Here you set up the custom table to have a master table. For example, if you create a table that has debtor as the master table and insert the user table in the menu in the debtor table, you will only see the records that belong to the selected debtor. New records that are created will also have the debtor stamped on the record. A custom table that has "primary key" set can also be the master for other custom tables.
The report generator can also display these sub-tables in a master/detail report. Custom tables cannot be displayed in custom reports, such as invoice, order confirmations, etc.
For creating fields in the table. Tap on [Fields]. Read more about field creation.
SQL is not used yet.
Speed of search on your own tabs
The speed of a search in SQL depends on whether a field is indexed or not. The tables have an underlying SQL table for custom tables where a field - "Date" - is predefined and included in the indexing.
When creating a custom table, you can select "Default" and "Entries" in the "Type table" field. "Entries" is the table that is indexed on "MasterRow, Date".
If you have a table with data that is "Standard" and you want to switch to "Entries", you need to export your data, delete all rows, change the table type and then import your data again.