>Yes, the other perspective was a future developer/analyst, but the main issue really is the relationship between the 3 tables, it is easier, and more practical (I would have thought) to have 3 tables related to each other rather than 3 records related to each other.
>
>Kev

Ooo. Kevin I think we were misguided from the beginning :) Is this something needing recursion in itself like :
emp_id, reportsto where reportsto is another employee ?

If so 'use again' would be more natural but beware 'use again' tables are like tables used by others in network. IOW if buffering is used each 'use again'ed cursor would see buffer of itself only.
Cetin