Skip to main content

Managing Tables

Last updated 19/03/2024

This documentation will aid you to upkeep your table records. All your table records will be listed in the Tables view whether they have been added via the Table form, the Table Wizard, or the Database Modeler.

Edit a Table Record

1. Select the table record in the list.

2. Either click the Edit button in the form app bar, or click directly in a field.


Edit button
Figure 1 - Edit button

3. Make your changes.

4. Click the Save button in the form app bar.


Save button
Figure 2 - Save button

Delete a Table Record

1. Select the table record in the list.

2. Click the Edit button in the form app bar.


Edit button
Figure 3 - Edit button

3. Click the Delete button in the form app bar.


Delete button
Figure 4 - Delete button

caution
Five will ask you 'Do you want to delete this record?' because once a table record has been deleted, all fields and indices will also be deleted.

tip
Any functions attached to your table will still be available in the Functions view!

4. Click the Yes button.


Yes button
Figure 5 - Yes button

Edit a Field Record

1. Select the table record in the list.

2. Click the Fields tab.


Fields tab
Figure 6 - Fields tab

3. Select the field record in the list.


Field record
Figure 7 - Field record

4. Either click the Edit button in the form app bar, or click directly in a field.


Edit button
Figure 8 - Edit button

5. Make your changes.

6. Click the Save button in the form app bar.


Save button
Figure 9 - Save button

7. Click the Save button in the form app bar above the list.


Save button
Figure 10 - Save button

Delete a Field Record

1. Select the table record in the list.

2. Click the Fields tab.


Fields tab
Figure 11 - Fields tab

3. Select the field record in the list.


Field record
Figure 12 - Field record

4. Click the Edit button in the form app bar.


Edit button
Figure 13 - Edit button

5. Click the Delete button in the form app bar.


Delete button
Figure 14 - Delete button

info
A record will be displayed in a bright yellow color in the list when it has been flagged to be deleted.

6. Click the Save button in the form app bar above the list.


Save button
Figure 15 - Save button

Edit an Index Record

1. Select the table record in the list.

2. Click the Indices tab.


Indices tab
Figure 16 - Indices tab

3. Select the index record in the list.


Index record
Figure 17 - Index record

4. Either click the Edit button in the form app bar, or click directly in a field.


Edit button
Figure 18 - Edit button

5. Make your changes.

6. Click the Save button in the form app bar.


Save button
Figure 19 - Save button

7. Click the Save button in the form app bar above the list.


Save button
Figure 20 - Save button

Delete an Index Record

1. Select the table record in the list.

2. Click the Indices tab.


Indices tab
Figure 21 - Indices tab

3. Select the index record in the list.


Index record
Figure 22 - Index record

4. Click the Edit button in the form app bar.


Edit button
Figure 23 - Edit button

5. Click the Delete button in the form app bar.


Delete button
Figure 24 - Delete button

6. Click the Save button in the form app bar above the list.


Save button
Figure 25 - Save button

Create Table

caution
The Create Table button will remove all the data in the table, effectively resetting the table. It is strongly recommended to backup your data by exporting it into a CSV file, before using the Create Table button.

1. Select the table record in the list.

2. Click the Create Table button in the form app bar.


Create Table button
Figure 26 - Create Table button

3. Click the OK button to create the table.


OK button
Figure 27 - OK button

4. Click the OK button.


OK button
Figure 28 - OK button