To create SHAPEd recordset, use the DataEnvironment. Create a Command for the Parent query (Customer) and then create a second Command for the child (CustomerDetails). Then in the Relate tab, relate your child to the parent. The SHAPE will be done for you.
>Hi..
>
>These are my seperate select statements that I would like to relate...
>
>I am unable to return a hierarchical data set for the following.
>
>Query 1
>--------
>SELECT Name FROM Customer
>
>
>Query 2
>-------
>SELECT Name,IndividualChars FROM CustomerDetails
>
>
>
>I want to relate Name from Query 1 to Name in Query 2... This does not seem to work....
>
>Is there some rule that you can only relate 2 fields that are Primary Keys?
>
>Thanks a bunch,
>
>Alvin
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com