You can add another append statement to your first child statement
	APPEND ({SELECT ISBN, Title, Author, Quantity, OrderId FROM 
RPT_OrderLineItems
	ORDER BY LineItemNbr} AS IsbnDetail
          RELATE 'ISBN' To 'ISBN'

> -----Original Message-----
> From:	vwindrow@m... [SMTP:vwindrow@m...]
> Sent:	Friday, October 18, 2002 2:02 AM
> To:	professional vb
> Subject:	[pro_vb] Re: how to connect
>
>
> I hope that someone can help me out with this problem soon.
>
> This would be the sql to grab the other table.  But what I don't know 
what
> to do is somehow combine this with the other sql I mentioned in the 
first
> posting. And have the second flex grid with the below information 
become
> the child of the 1st flex grid, so that when a row is selected in the
> first one the corresponding line items is populated in the second 
grid.
>
>
>
> SELECT ISBN, Title, Author, Quantity, OrderId FROM RPT_OrderLineItems
> ORDER BY LineItemNbr
>
> I do not know how to properly get the syntax to do this, I tried this 
but
> I am obviously not getting the sytax exactly right.
>
> {SELECT OrderDate, OrderId FROM Orders WHERE (Status =3D 1)}  AS 
Orders
> APPEND ({SELECT ISBN, Title, Author, Quantity, OrderId FROM
> RPT_OrderLineItems ORDER BY LineItemNbr}  AS LineItem RELATE 'OrderId' 

> TO 'OrderId') AS LineItem
>
> ---
> Visual C# - A Guide for VB6 Developers
> This book will make it easy to transfer your skills
> from Visual Basic 6 to C#, the language of choice
> of the .NET Framework.
> http://www.wrox.com/ACON11.asp?ISBN=3D1861007175&p2p0059
>