Thanks
here is a sample:
I use text merge endtext to fill in the data and that works just fine.
I was just wondering if there is a better way

<?xml version="1.0"?>
<!--File Name: CT_AP001.XML -->
<CTAPI001A>
   <CT_AP001_HDR>
      	<BUSINESS_UNIT>OTTIU</BUSINESS_UNIT>
        <VOUCHER_ID>1</VOUCHER_ID> 
	<CT_VCHR_INTFC_SRCE>OTT</CT_VCHR_INTFC_SRCE>
	<ORIGIN>OTT</ORIGIN>
	<INVOICE_ID>OTT2189</INVOICE_ID>
        <INVOICE_DT>04/04/2003</INVOICE_DT>
        <ACCOUNTING_DT>04/04/2003</ACCOUNTING_DT>
        <VENDOR_SETID>OTTIU</VENDOR_SETID>
        <NAME1>PELER, Jiody</NAME1>
        <NAME2>EXEC</NAME2> 
        <VNDR_NAME_SHRT_USR>045991234</VNDR_NAME_SHRT_USR>
        <CT_RECEIPT_DT>12/04/2003</CT_RECEIPT_DT>
        <COUNTRY>USA</COUNTRY>
        <ADDRESS1>36 MIDDLE AVE</ADDRESS1>
        <CITY>MyTown</CITY>
        <STATE>CT</STATE>
        <POSTAL>06109</POSTAL>
        <OPRID>MaidelisI</OPRID>
        <GROSS_AMT>524.44</GROSS_AMT>
        <CT_AP001_PMNT>
          <BUSINESS_UNIT>OTTIU</BUSINESS_UNIT>
          <VOUCHER_ID>1</VOUCHER_ID>
          <MESSAGE_CD>UNCLAI</MESSAGE_CD>
          <PYMNT_GROSS_AMT>524.44</PYMNT_GROSS_AMT>
          <PYMNT_HANDLING_CD>RE</PYMNT_HANDLING_CD>
         </CT_AP001_PMNT>
        <CT_AP001_LINE>
          <BUSINESS_UNIT>OTTIU</BUSINESS_UNIT>
          <VOUCHER_ID>1</VOUCHER_ID>
          <VOUCHER_LINE_NUM>1</VOUCHER_LINE_NUM>
          <LINE_DESCR>PAYMENT IN FULL</LINE_DESCR>
          <MERCHANDISE_AMT>524.44</MERCHANDISE_AMT>
          <CT_AP001_DIST>
             <BUSINESS_UNIT>OTTIU</BUSINESS_UNIT>
             <VOUCHER_ID>1</VOUCHER_ID>
             <VOUCHER_LINE_NUM>1</VOUCHER_LINE_NUM>
             <DISTRIB_LINE_NUM>1</DISTRIB_LINE_NUM>
             <MERCHANDISE_AMT>524.44</MERCHANDISE_AMT>
             <BUSINESS_UNIT_GL>STATE</BUSINESS_UNIT_GL>
             <ACCOUNT>54830</ACCOUNT>
             <FUND_CODE>11000</FUND_CODE>
             <CLASS_FLD>12002</CLASS_FLD>
             <PROGRAM_CODE>13019</PROGRAM_CODE>
             <PROJECT_ID>OTT_NONPROJECT</PROJECT_ID>
             <DEPTID>OTT14620</DEPTID>
             <BUDGET_DT>04/04/2004</BUDGET_DT>
             <BUDGET_REF>2004</BUDGET_REF>
          </CT_AP001_DIST>     
	 </CT_AP001_LINE>
       </CT_AP001_HDR> 
     </CTAPI001A>
   

>>>>Any free tool for VFP6/7 to convert hierarchy XML to cursor and so forth ?
>>>
>>>Visual FoxPro 8.0 supports this. Do you plan to upgrade to VFP 8.0?
>>
>>How?
>>
>>I tried that but it puts the child record data into a field instead if creating a cursor for each table in the hierarchy
>>
>>Peter
>
>Hi Peter,
>
>Ken was talking about new XMLAdapter class. Have you tried it?
>If you post a small example of XML along with XML schema, I'll probably be able to help you.
>
>Thanks,
>Aleksey.