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