>Hello Dragan,
>
>Sorry for the delay. Was having a problem with my internet service provider, so was offline all these days.
>
>Thanks very much for your reply. I tried the simple stuff first, like opening the database exclusive before using referential integrity, and I seem to have crossed the first hurdle, thanks to you.
>
>However, would you be able to tell me what referential integrity parameters are passed to make the parent and child table to delete a record together from within a view (for e.g.)?
Actually no, I wouldn't trust myself to tell anyone how to do that, as I've never done RI within the database. Wherever I worked, it was always in code outside of it - be it bizobjects or framework code.
I figure you need to select cascade (meaning if parent is deleted so are its children), but I really don't remember where. Last time I had that it was somewhere in a framework form, and I never looked under the hood to see how it looks in the DBC.