Two weeks ago I finally got figured out how to auto-generate primary keys for my application (with the help of some very nice developers on this website I might add). I thought my problems were over!

Anyway, everything was working great until I had the Referential Integrity Builder generate code for all my joins. Now, when I try to append a new record to some of my tables, some tables generate sequential numbers, and some of them give me an error message, saying "FAILED TRIGGER".

It might be important to note that in my "keylist" table I set up to have my tables auto-generate primary keys, even the tables that give me the error message, show the numbers increasing in the keylist table. The keylist table is doing what is should be doing, however, my problem lyes with the failed trigger.

If someone could tell me how to alleviate this problem, I would appreciate it very much.

Thanks in advance

jcd