Skip to main content

Add a Table

Last updated 23/10/2023

How to Add a Table with Five's Table Wizard​

Learn how to add a table in Five with Five's Table Wizard. This is the first tutorial in a series of four videos. It is highly recommended that you read the Introduction chapter on Five's Table Wizard before creating your first table. This will explain how to access the Table Wizard and the record once it has been saved.


Add a Table​


tip
Five's Table Wizard will create your PRIMARY KEY field and index!

info
When you create a table, normally you are required to add a PRIMARY KEY field and index. The PRIMARY KEY constraint uniquely identifies each record in a table. When you create a table with Five's Table Wizard, you DO NOT need to create the PRIMARY KEY as Five does this automatically.

1. Type a name in the Name field.


Add a Table
Figure 1 - Add a table

2. Click the Add Fields button.

3. Type a name in the Name field.

4. Configure the definitions for your field, by either adding a value or using the lookup icons and selecting a value.


Add a Field
Figure 2 - Add a field

5. Click the Add Fields button to continue to add more fields to your table.


Add Multiple Fields
Figure 3 - Add multiple fields

6. Click the Save button in the Table Wizard app bar.


Save the table
Figure 4 - Save the table

7. Click the Save button in the Table Upgrade window.


Save the table upgrade
Figure 5 - Save the table upgrade

info
The Table Wizard may take a few seconds to reload.

tip
The record is located in the Tables view!