>Bill
>
>It depends whether you are using a C/S backend or local tables.
>
>With local tables, it's easy. Create a function with foreign key as parameter, that builds the child data into a string. E.G. if your invoice primary key is iInvoice and the invoice rows are joined on thet field, you could use
>
>

>FUNCTION f_GetRows(liInvoice)
>*---Receives invoice key as parameter, builds string based on invoice rows
>
>LOCAL lcString,lxSelect
>
>*---Save currently selected table so we can restore
>lxSelect=SELECT()
>
>*---Get the invoice rows for the selected invoice
>SELECT * FROM invoiceRows WHERE iInvoice=?liInvoice ORDER BY iRowNumber INTO CURSOR c_InvoiceRows
>
>*---Build the String
>lcString=""
>SCAN
> lcString=lcString+...
>...
>ENDSCAN
>
>*---Restore selected table
>SELECT (lxSelect)
>
>*---Make sure string>255 characters so it will be a memo field in SQL
>IF LEN(lcString)<255
> lcString=PADR(lcString,255)
>ENDIF
>
>RETURN lcString
>

>
>Then you can use SQL to get what you need:
>
>Select invoices.*,f_Getrows(invoices.iInvoice) as mString from invoices WHERE...
>
>HTH
>
>Regards
>
>JR

John,
Are you sure making string longer than 255 would make it a memo in SQL ?
Cetin