Corel wordperfect office 2002 Benutzerhandbuch
3 Click Add.
4 Type a picture name in the Pictures list.
5 Click Code syntax to view valid picture codes.
6 Type a code in the Picture code box.
4 Type a picture name in the Pictures list.
5 Click Code syntax to view valid picture codes.
6 Type a code in the Picture code box.
An example of a code would be: ####.
7 Type a sample value in the Sample value box.
An example of a sample value would be: 1234.
8 Type a description for the picture in the Description box.
To set a field as mandatory
In the Create table dialog box, enable the Req’d check box for the appropriate field name.
Establishing a secondary index
Secondary indexes help you to sort the records in your table and to retrieve data. When you
create a secondary index on a field, the table’s records sort under that field instead of under the
key field (the default).
To establish a secondary index
1 Click Format } Restructure table.
2 Click the Secondary index tab.
3 Click Add.
4 Type a name for the index in the Index names list.
2 Click the Secondary index tab.
3 Click Add.
4 Type a name for the index in the Index names list.
Usually this takes the name of the field on which you set the index.
5 Choose a field from the Fields list.
6 Click the right arrow.
7 In the Index options area, enable one or more of the following options:
6 Click the right arrow.
7 In the Index options area, enable one or more of the following options:
Unique
¾
requires that the value entered exists only once. If Paradox detects a duplicate
value, a warning message appears and the index is not created.
Maintained
¾
instructs Paradox to update the index each time the table changes. This
setting is essential to speed up queries and to support linked tables.
Case sensitive
¾
determines whether capitalization is considered when sorting records
8 Click Save.
Creating a lookup table
Lookup tables provide a quick way to access acceptable values for a given field. They also control
the accuracy of the data entered into your database.
356
Paradox 10