Hi
I have a database which is used to keep track of industrial objects for a project. For each record (object) there are a connecting revision table (one to many) which is utilized to keep track of data changes for the object (revision handeling).
Data structure:
-Main Table
*Revision Table
The interface is a split form with a subdatasheet form for the revision handeling. I want the user to have the possibility to work in both views (form view and datasheet view).
Now to the issue, when deleting or copying records in the subdatasheet form I get the notification "This Operation is not supported within transactions" and the operation is not carried out (even if it looks like the records are deleted).
When directly in datasheet view for the main form this problem does not occur.
I have made a video of the issue: