Ok, I have a table, here is some sample data<BR><BR>ID___ParentID___Name<BR>1____0________ __blah<BR>2____0__________blahh<BR>3____2_________ _Blahhh<BR><BR>ParentID points to ID to make a hierarchical effect... I know its called a foreign key when it points to another table, what’s it called when it points to another field in the same table...<BR><BR>My anal retentive boss wants precise documentation on my asp/database site... any info would help... thanks in advance...<BR><BR>~The Other Steve<BR>