ssuing8825 wrote: > If you want to bind the whole table. Join the tables in the query > when you pull it out of the database. That way the desc will be on > the same row as the product. > > Your allowed to de-normalize if it makes your life easier.
A good trick is to make that a UDF in your database. This is real nice when your keys are GUIDs. Select GetCust(CustID) as [Customer Number] , GetInvoice(InvoiceID) as [Invoice Number], GetInvDetails(InvID) as Item, invoiceDetail.QtyOrd, .... >From InvoiceDetails Where ..... Stephen Russell S.R. & Associates Memphis, TN 38115 901.246-0159 ------------------------ Yahoo! Groups Sponsor ---------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM ---------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
