Hi

I am getting an error message -- "Trigger Failure" when I try to append a record. I have no idea how to alleviate the problem.

The problem surfaced recently when I used the Referential Integrity Builder to produce code for my joins. After I performed that function, I immediately encountered problems. Prior to this, I was able to append a new record to any of my tables without a problem. It interesting to note that some of my tables still auto-generate primary keys, just as they have been. It is only 3 tables that cause the error message to surface.

> Is my "GetKey" program, which is a stored proceedure, causing problems with the triggers that the RI builder set in place.....which are also stored proceedures? I am just guessing.

I would certainly appreciate anyone's solution or comments to this problem.

Thank you very much in advance for for your time.

Jason