Work Area Properties Dialog Box

Dialog Box Options

Cursor

Displays the title of the currently opened table.

Enable data buffering

Sets buffering on.

Lock Records

When edited

Prevents access by other users while you edit records. This is also known as pessimistic buffering.

When written

Permits access by other users until the record is updated. This is also known as optimistic buffering.

Buffer

Current record

Enables buffering of the current record only. This is also known as record buffering.

All edited records

Enables buffering of all edited records. This is also known as table buffering.

Note When you select Buffer Current Record, Multilocks are automatically set to ON (if they are currently off), but are not set to OFF if you clear Buffer Current Record or select Buffer All Edited Records. Set the defaults for new tables in the Data tab of the Options dialog box.

Data filter

Provides a text box for typing a data filter expression. Alternatively, the dialog button displays the Expression Builder dialog box, in which you can specify which records in the active table will be available for processing. Corresponds to the SET FILTER command.

Index order

Specifies the index order of the table. In the Database Designer, the table's primary index appears with a key symbol next to it in the list of indexes. Corresponds to the SET ORDER command.

Allow Access To

All fields in the work area

Specifies that the user have access to all fields in the work area. Corresponds to the SET FIELDS command.

Only fields specified by field filter

Specifies that only records which match the selections in the Field Picker dialog box be displayed or available for editing.

Field Filter

Displays the Field Picker dialog box, in which you control the number of active fields.

Modify

Displays the Table Designer, in which you can modify database and free tables, fields, and indexes.

For more information, see "Customizing Tables" in Chapter 2, Creating Tables and Indexes in the User's Guide.