Hi Madya

The question is whether you control data entry with a rule a) enforced in the application code or b) by the database.

My take is that there is no best answer, but rather a case of perspective. SQL and Oracle people will probably say use table rules. I go the otherway and try to have a business rule in the code to handle it. Why? Because I might want to switch database engines (VFP to MS SQL or mySQL). My belief is that I will have less refactoring to do if I enforce all of the rules in the application, fewer places to look when something goes wrong. Not to be misleading, I do use RI, but the triggers refer to code.

- Don Lowrey