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

Interesting. I use default foreign keys for things like state names. The state form has a checkbox so the user can set that state as the default. The the default proc gets it out of the Keys table.