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??