image20

The Restrict deletion Rule prevents a row from being deleted if it corresponds with data elsewhere in the database. For example, if a transaction refers to a customer, the customer cannot be deleted from the customer table in a way similar to a Primary Key.


ð Rule

Where  
The WHERE clause that creates the lookup for the condition.  

Where Builder  
Opens the WHERE Builder dialog to create your WHERE clause using a GUI interface.  
 
Message  
The "condition not met" message to display for the user.  
 
[Succeed|Fail]  
Determines if the Message is displayed if the condition Succeeds or Fails.  
 
[Add/Modify|Delete]  
Determines if the Rule is checked when a row is Added or an existing row is Modified, or if an existing row is Deleted.