>I have two table setup with a one-to-one relationship. The RI - is set to Cascade,Restrict,Restrict. I can add a record to the parent table, but when I do an Append Blank in the chilc table I get a trigger failure. This all makes sense to me and I think I understand why.
>
>But then how can you add a new record to the child table with RI enforced??
Hi Chad.

Make sure that you have the parent record's primary key in the child record before doing a tableupdate. If you are not using buffering, use insert into to populate the child table instead of append blank.

Marcia