Take a look at this article:
http://msdn.microsoft.com/library/techart/adojump.htmI believe the Hierarchical/shaped recordsetes section is what you're looking for, and the whole article is a great introduction to ADO.
>Using ADO in Fox, can you access tables from SQL server and set a relation ship on the recordset the same as you can in foxpro? Ex: You ahe a form tahe has a header section for the one relationship and a grid that shows the meny relationship. As you know, in fox when you scroll through the one relationships you could see four associated items in the grid displaying the many.
> This is what i would like to do!!!