>>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.
>
>For a simple application I would use built-in RI builder. But If I want to have more control over the triggers I would use my functions to do that.
Since your advice is the exact opposite of Ed's I'll try a mixture of both. <g>
Thanks a lot.
If it's not broken, fix it until it is.
My Blog