The Key/Indexes tab allows you to specify table constraints such as Primary Keys, Foreign Keys, Unique Keys, and Indexes.
Fields
ð Message on insert of a FK value not in the referenced table
|
|
| A non-editable field which displays the message which will appear to the user when they try to insert a value in the field which does not appear in the PK table. This message is defined when the key is added.
|
|
|
|
|
| A non-editable field which displays the message which will appear to the user when they try to update a value in the field to something which does not appear in the PK table. This message is defined when the key is added.
|
|
|
|
|
| This button allows you to create a new key/index by opening the Select Columns dialog.
|
|
|
|
|
| Deletes the currently selected key/index. If you try to delete a key which is referenced by another table, you will receive an error message about releasing the dependencies first.
|
|
|
| Commits any chages made since the last save.
|