build apps by user

Define Database Table and Field of a Cell

Each cell of a worksheet is associated with a table field in the actual database file, so that the piece of data can be stored in that table and field. Let’s define the tables and fields in the properties of Input Pane.
input pane properties - table and field settings

Table and Field Properties of a Cell

It’s easy to define the table and field properties filling the properties in the same row of the associated cell in Input Pane setting. When table and field properties are saved and confirmed, press  Update DB Tables   button in the bottom to create the tables and fields in the database file.
 Table
The name of the database table associated with the cell.
 Field
The name of the field of the database table associated with the cell .
 Type
The type of data that will be stored in the field .
Data Type Description
Text String of characters and words, maximum length is 255 characters. Example : abc, street, customer, … etc.
Memo Same as Text but longer, maximum length is 65,536 characters. It is useful when many words need to be stored in a field.
Date Calendar date and time. A Date field can store a date value only, a time value only or a combined date and time value. Example : 2018/5/10 10:25:58 PM
Integer The number is an integer, without fractional part. Value ranges from -32,768 to +32,767. Example : 1, 2, 3, -98, -100, etc.
Long Same as “Integer”, with a much greater value. Value range from –2,147,483,648 to 2,147,486,647.
Single A number that can have fractional part (decimal value).
Double Same as “Single”, with much larger value and precision.
Currency A numeric value for used with financial values. Value range from –922,337,203,477.5808 to 922,337,203,685,477.5807. A maximum of 4 decimal places is allowed.
Boolean A logical value with value either True or False.
 Size
It is meaningful when you define the field type as Text. It defines the length, or number of characters, of the text field, with value from 1 to 255.

Cell Without Database Table and Field

A cell can has not association with the actual database. In this case, just leave  Table   and  Field   to be blank.
A cell with no table and field attached can be a label cell, used for displaying information in Info Pane, or as a spacer.