>>>>I set persistant relations in the DBC to handle Referential Integrity.
>>
>>>You mean making sure no orphans are created?
>
>>That is part of what RI does for you. It can also:
>
>>- Prohibit delete of parent if children exist
>>- Cascade delete so that children get deleted with parent
>>- Prohibit addition of child if no parent exists
>>- Change the foreign key in the child when the parent record changes
>
>Thanks Mr. Berntson. I was just checking to see if there was anything about PR that I was missing. You never know unless you hear it from an expert. :)
I wouldn't say I'm an expert...just another guy sharing his knowledge.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer