I have a program in VB6. Now, i'm trying to migrate the database from access to SQL Server, but i found a problem with a Hierarchical Recordset (it works perfect on Microsoft Access). I use the DataEnvironment component to implement all the ADO Recordsets. The problem is when i open the recordset, because it shows the child records and the child fields ( not the parent recordset using the last field to access the child recordset). I really don't know how to resolve this.