General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Deleting/Updating a record in a multitable view
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.
Thanks!
Steve
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only