We are trying to add records to a table that has referential integrity triggers to two other tables. When the code tries to add the record we get "error 1539" trigger failed. How can we get past this?

The form just uses SCATTER MEMVAR BLANK to prepare the M.fields to hold values from the text boxes.

The Ref. Integrity is defined as cascade.

cTable1 - the table we're trying to INSERT INTO MEMVAR
pTable2, pTable3 - other two tables that are just dropdown listings to choose from in the form and then that value goes to M.fieldname

ParentTable ChildTable Update Delete Insert
pTable1 cTable1 Cascade Restrict Restrict

This seems like it ought to be simple.

Any thoughts?