The following is just a small sample of a pice of code that will do what you want. (tables involved: service1 and servinv) Service is the header and servinv is the actual line items.

SELECT service.company as 'company', service.order_no as 'orderno',;
servinv.mfg_part,servinv.part_number,servinv.qtyord,servinv.new_used,;
servinv.qtystaged,servinv.tech_no,servinv.tech,servinv.qtyinstall,;
servinv.qtyremaining;
FROM sys2000!servinv INNER JOIN sys2000!service ;
ON servinv.sonum = service.order_no ;
WHERE service.order_no = vOrderno ;
ORDER BY servinv.mfg_part;
INTO CURSOR parts NOFILTER

Produces a list like:

Service Service Servinv

'abc company' '12345' 'partabc' etc.......

Bryan Holmstrom