Triggers work fine when validation is expected to be performed on a row
at a time. But how about when validation is based on several rows ?
For example,
Say a team (group of employees) work with every customer and they each
get some % credit for every deal made with the client. Total % for the
team should be 100. Where do you put this check ? It can't be when one
team member row gets saved. Check should be after all the team member rows
for the team get saved. Now, how do you do that ?
Received on Thu Dec 30 1999 - 15:53:03 CST
