Having this strange problem with an application I created.
The form has 2 tables that are related as 1-to-many with
table buffering on. The problem occurs when I try to delete
a record from the parent table. After marking the record as deleted,
I execute the tableupdate command, but the tableupdate fails. In my error
handling routine I get the error # 1539 (Trigger Failed).
What's strange is that when I try to delete the record from
the command window, the delete works perfectly.
I've search the microsoft knowledge base, but there doesn't
seem to be anything that relates to my specific problem.
Any help would be greatly appreciated.