>>>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.
:o)))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.