Applications

 

Help Sections:

General

Writer

Impress

Math

Draw

Calc

Base

Basic

Index design

The Index Design dialog allows you edit the indexes for the current table.

Table Design

Index list

Displays the available indexes. Select an index from the list to edit. The corresponding details of the selected index are then visible on the right side of the dialog.

New Index

Creates a new index.

Delete Current Index

Deletes the current index.

Rename Current Index

Renames the current index.

Save Current Index

Saves the current index in the data source.

Reset Current Index

Resets the current index to the setting that it had when the dialog was started.

Index details

As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the Reset Current Index icon.

Unique

Specifies whether the current index allows only unique values. Checking the Unique option prevents duplicate data from being entered in the field and ensures data integrity.

Fields

The Fields area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list.

Index field

Displays the a list fields in the current table. You can select more than one field.

Sort order

Determines the sort order.

Close

Closes the dialog.

Index

This help text is published from the OpenOffice-Help files under the Public Documentation License 1.0.