Hi Alex,

Its one parent table and a one child table.

Here's the genreal setup for info

TABLE A is parent to TABLE B and TABLE X

TABLE B is parent to TABLE C. A surrogate PK, FK to TABLE B, and some entry data.

TABLE X contains the default values for TABLE A

TABLE C contains the user modifed default values. A surrogate PK, FKs to TABLE B and TABLE X, and the modified default.


I have it somewhat working by querying the child table with the new parent key value, result is empty, then I requery a view that has the defaults, cycle throught that defaults view calling the NEW() of the child BizObj and replacing the with the default values. Only problem in this method is when I display the child records for the user its at the bottom of the file and any attempt to move the record pointer to the top prior to the display causes the cannot insert empty rows into base table errror.

I thought about the new method as well but for somereason rejected it....maybe worth investigating it again.


Thanks for the reply.