Mark,
My FK Default Value for child tables is a UDF: ParentKey( "ParentTableName.iID" ) I use a udf so I can trap parent table not open errors.
>Yes, you're right. But that breaks up the processing. You have to TableUpdate the parent, then Replace the foreign key in the child, then TableUpdate the child.
>
>The way my framework works, you add both the child and the parent record, default the fields that can't be defaulted automatically (including replacing the parent foreign key in the child record), allow edits, then do the TableUpdates.
>
>I guess this approach isn't better than another, though. It does seem to me that it makes the child record logically consistent at an earlier stage, but that's not necessarily better.