Corel wordperfect office 2002 Manuel D’Utilisation
All
¾
gives full rights to all table functions, including the ability to change and delete
passwords
Insert & delete
¾
records can be added, edited, and deleted. The table cannot be deleted
or restructured.
Data entry
¾
records can be added or edited but not deleted. The table cannot be
deleted or restructured.
Update
¾
only non-key fields can be edited.
Read Only
¾
the user can only view data.
7 Click the access cell to the right of the selected field name, and choose one of the following
levels of field access from the list box:
Full
¾
there are no restrictions
Read Only
¾
the user can only view data
None
¾
the user has no rights to this field and Paradox does not display the values in this
field
In the case of linked tables, you must add the password to the child table before the
parent table.
Passwords are case-sensitive.
Passwords are case-sensitive.
Establishing referential integrity
Referential integrity is very important when creating multiple relationships between tables.
Referential integrity ensures that the values in a table are valid. It requires a field or group of
fields in one table (the child table) to refer to the key of another table (the parent table) to
determine valid values.
To establish referential integrity
1 Open a child table.
2 Click Format } Restructure table.
3 Click the Referential integrity tab.
4 Click Add.
5 Type a name in the Link names list.
6 Choose the parent table from the Parent table list box.
7 Choose the parent key from the Parent's key list.
2 Click Format } Restructure table.
3 Click the Referential integrity tab.
4 Click Add.
5 Type a name in the Link names list.
6 Choose the parent table from the Parent table list box.
7 Choose the parent key from the Parent's key list.
If the parent table has a composite key, add fields to match all of the parent's key fields.
8 Click the left arrow.
9 Enable one of the following options in the Update rule area:
9 Enable one of the following options in the Update rule area:
Cascade
¾
any change you make to a value in the key field of the parent table is
automatically made in the linked field of the child table
Prohibit
¾
you cannot change a value in the parent table key field if there are records
that match that value in the child table
Strict R.I.
¾
ensures that earlier versions of Paradox cannot access a table on which
you’ve established referential integrity. Paradox must obtain locks on all tables involved in
a referential integrity relationship when you modify it.
358
Paradox 10