soory what i mean is that i have a table with the follwoing cols:

AccId numeric

AccCustumId numeric

what i need is to define the Default value...

Thank you NPeeters for your clearfication,

but each child belond to one pernt.

can you please tell me more about cascaded triggers, I think it will help solve the problem.

Thanks Frank,

Yes the parent project has op_parent_id = NULL, and a subproject op_parent_id = op_id of the parent. and to make it more clear this is an example

op_id ...