Tables are used to capture a collection of records with a uniform structure. If you think of a employee information as a table, the same set of information is stored for every employee like employee name, id, date of joining ..etc. Where each piece of information about the employee corresponds to a field in the record. The table itself would hold all employee records. With that in mind it is best to choose a name for the table that describes what it holds, for example employees.
It is recommended that you create tables in your own workspace. If you have not created a project workspace, create one as described in Using Workspaces.
Click on Tables in the top menu and then select create tables which will prompt you for a name for the table.
The next step is to define what a record will contain. A record contains fields which identify specific pieces of information that need to be captured. In the example table employees, employee name is a field which holds the name as text and id is a field which holds the employee id as a number and so on.
You can define record structure using the tables wizard. Type a field name, choose a corresponding data type and click on Add Field. The record structure will get updated and is displayed on the right panel. LyteRAD supports a number of datatypes refer Choosing datatypes for more information. Repeat this for every field in the record.
Before saving the record structure, you need to specify a primary key which can uniquely identify a record. In the example table employees the employee ID is a field which is unique, that is no two employees can have the same id. By making the employee ID as the primary key, the id can be used locate employee information without ambiguity. Select one of the fields in your record structure as the primary key.
Click on Save Table to save the changes and you are ready to use the table.
Tip: If there is no field with unique values, add a autoinc field which will be automatically generated and guaranteed to be unique. This can be used as a primary key for the table.