>>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer