>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.
Before inserting, make sure the variables for the fields which relate to lookup tables have valid values, and if they don't, issue a message, return .f. from validation or do whatever you do when you don't allow the user to save. And don't try to insert if these aren't valid.