Corel wordperfect office 2002 Manual De Usuario
To create a lookup table
1 Click Format } Restructure table.
2 Click the Table lookup tab.
3 From the Fields (Current Table) list, choose the field to which you want to assign the lookup.
4 From the Lookups defined area, click the right arrow to move the field name to the Field
2 Click the Table lookup tab.
3 From the Fields (Current Table) list, choose the field to which you want to assign the lookup.
4 From the Lookups defined area, click the right arrow to move the field name to the Field
column.
5 From the Lookup tables list box, choose the table you want to use as the lookup table.
6 Click the left arrow to move the table name to the Lookup table column.
7 In the Lookup type area, enable one of the following options:
6 Click the left arrow to move the table name to the Lookup table column.
7 In the Lookup type area, enable one of the following options:
Current fields
¾
only the current field gets its value from the lookup table even if the
current table and the lookup table have other fields in common
Applicable fields
¾
all fields of the current table that correspond to fields in the lookup
table take their values from the lookup table
8 In the Lookup rights area, enable one of the following options:
Fill only
¾
does not allow the user to view the lookup table when editing a table and
informs the user when the value is invalid. This option is useful when you want to keep
values in your lookup table secure. An authorized user will know the correct value.
Fill and view
¾
allows the user to display and select values from the lookup table while
editing a table
9 Click Save.
When you create a lookup table, its fields must have identical attributes (field name,
type and size) to the fields in the table to which values will be copied.
Creating Passwords
Passwords let you control who has access to your data. You can assign a master password for
your table and you can assign auxiliary passwords to give access at the table and field levels. You
must create a master password before you can assign an auxiliary password.
To assign a master password
1 Click Format } Restructure table.
2 Click the Passwords tab.
3 Click Define.
4 Type a password in the Password box.
5 Type the same password again in the Verify password box.
2 Click the Passwords tab.
3 Click Define.
4 Type a password in the Password box.
5 Type the same password again in the Verify password box.
To assign an auxiliary password
1 Click Format } Restructure table.
2 Click the Passwords tab.
3 Click Add.
4 Type a name in the Auxiliary passwords area.
5 In the Table rights area, enable the check box for the appropriate table-level access rights.
6 Click one or more of the following check boxes:
2 Click the Passwords tab.
3 Click Add.
4 Type a name in the Auxiliary passwords area.
5 In the Table rights area, enable the check box for the appropriate table-level access rights.
6 Click one or more of the following check boxes:
Working with tables and records
357