I have a table in a database that I need to add record validation to. The problem is that some of the fields need the validation while others do not.

For instance, My table has 10 fields. 8 of them need to pass a validation clause before they can be updated. The other 2 fields can be updated at any time.

So if a user changes data in one of the 2 fields, there is on validation, it lets him continue without any validation.

But if a user changes data in one of the 8 fields, it applys a rule.

any ideas on how to accomplish this?