>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only