>My "parent_id" default value is a stored procedure that generates unique id's. How will this affect your solution?
>
>TIA
>
>--lincoln

The parent_id in the parent table can be what you want unaffecting the solution. The parent_id in the child table is which is setted to 'iif...'. I asume that when users add record to the child table, the parent table pointer is in the apropiated record. Test it. Hope this helps.