>Mark,
>What does the insert trigger do? It may do some checks on the PK value and if it doesn't adhere to its rules, it returns .F..
>
>When you added a new record directly to the table, did you use APPEND BLANK or INSERT INTO. If the former, the trigger may return .F. because the PK field can't be blank.
>

Larry,

I tried your suggestion. I was using append blank, INSERT INTO worked without triggers firing - no problem.

Still don't know why the RI builder for this database says that fields are set to IGNORE for insert new records into Parent table fields when related Child records do not exist, but it won't let me APPEND BLANK a new record, maybe appends are not suppose to work that way. This system did not make use of surrogate keys, instead PKs/FKs are Custno, Orderno, etc. and some were single field tables, so the new value to append IS the PK value in those rows.

Thanks,
Mark