Share via


Work Area Properties Dialog Box

Lets you modify the structure of a table, select index files and fields, and define data filters. This dialog box appears when you choose Properties from the Table Menu.

  • 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, SET MULTILOCKS Command 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, 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.

See Also

Customizing Tables | Data Tab, Options Dialog Box | Database Designer | Expression Builder Dialog Box | Field Picker Dialog Box | SET FIELDS Command | SET FILTER Command | SET MULTILOCKS Command | SET ORDER Command | Table Designer