hierarchical recordset

I am trying to build a hierarchical recordset without using the data environment designer. Is this possible? If yes, how? Any examples? Code?
Thanks! Christa