>>"A customer must have a salesperson" is exactly what is expressed by the business rule above.
>
>But the you add specific business procedures to it. That shouldn't be RI, RI would say, cascade, restrict, or ignore the delete, not "move it to the manageer record".
>
Hey Mike,
RI wouldn't say anything. It can't, it's just a property (or state) of the data. If the data has NO orphaned records it has RI, if it DOES have orhpaned records it doens't have RI. That's it. Basically what you said earlier.
The cascade, restrict, ignore stuff is just how you go about maintaining RI in the data. The code in those triggers isn't RI, because RI can't be code.
>So your right, the above is a business rule.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!