>>Hi everybody,
>>
>>I'm thinking, should I use the built-in RI Builder for a simple application or should I try to enforce RI rules from the interface?
>>
>>I have the following tables in a database:
>>
>>Tickets, Problems, Resolutions, ProblemResolution, Software, Hardware, Other.
>>
>>Tickets may have pointers to all of these tables. I allow to Delete Problems and Resolutions in the interface, I also allow to make inactive Software/Hardware/Other.
>>
>>What would be the best course of action for me to proceed in enforcing some integrity rules?
>>
>>What do you suggest?
>>
>>Thanks a lot in advance.
>
>I would enforce it on interface level. This is not a financial data after all.
Ok, after playing with RI builder and getting some weird errors I went with the simple interface solution for now and display a message right away. I added a method to our base form class called OkToDelete, so I can always display a message right at the time of the deletion, not at the Save time.
If it's not broken, fix it until it is.
My Blog