>Hi all,
>
>Strange, but true, I have gotten used to using stand-alone tables in the dataenvironment of my forms, instead of using views, because, at inception and design, I possibly found the learning curve too steep, and the benefits not inspiring enough at the time.
>
>Today, as I redesign my application using database features and views, here is one of the problems I encounter:
>
>I intend to delete a record in a multi-table view, which means, both the parent and the child record should go with a single delete command in a form. I have been working with the database, and trying to simulate the relationship in the view, click on the link, and develop a Referential Integrity. However, I get this error message:
>
>"This DBC is not open for exclusive use.You will not be allowed to generate RI through this DBC."
>
>Any help will be greatly appreciated.
I'd try the simple stuff first:
close data all
set exclusive on
open database {your dbc here}
modify database
Then come back here if it still won't.