This has two sections:

• Fields
• Records
   

Fields

This section is where you define the fields in the Table.

The Fields list shows all the fields in the Table. There is no limit to the number of fields you can have.

If the field is Indexed, a yellow lightning bolt symbol is shown. Hovering over this will display the type of index.

The Name column gives the Field name, and the Type column gives the datatype of the field.

The order of the fields is not important, but if you do specify a sequence it will be used by the Default Data Entry Form for users to fill the information in.

If you change the datatype of a field the system will attempt to preserve any existing data in any existing records, and no records will be removed.

To add a new field

1. Click Create...
2. Complete the Field dialog

To modify an existing field

1. Select the field in the field list
2. Click Edit...
3. Make any changes in the Field dialog

To remove a field

1. Select the field in the field list
2. Click Delete
3. Click Apply

Note: It is usually best-practice to start by adding a Record ID field. This will make subsequent configuration of queries etc easier.

 

Records

This section allows you to select the Record Identifier (or fields) to be displayed in dropdown listboxes and other pickers when you are presented with a list of records from the Table.

To select a single field to be the record identifier

1. Click the Radio-button against Field if not currently selected
2. Choose the field from the dropdown

To define an identifier made up of a combination of fields

1. Click the Radio-button against Combination if not currently selected
2. Click the button beside it.
3. The Combination dialog appears
   
   
   
   This contains a grid where the various fields that will be concatenated are selected.
   
   For each field to be included in the combination:
   1. Click Create...
   2. In the Prefix box, enter any text or spacing that should be added before the field
   3. In the Field box, select the field
   4. In the Suffix box, enter any text or spacing that should be added after the field

   Use the Arrow buttons to change the sequence of the fields in the combination
   
   To remove a field from the combination, select the field row and click Delete

4. Click OK to close the Combination dialog

 

When you have made a change in this section, you need to press the Apply button to save the changes.
 

Note: if you do not specify a record identifier, the system will default to using the Record ID (ie the integer assigned automatically to each record)