What error message did you get?

>There are additional fields in the currently open table before the select. It has about three extra logical fields that are required to the form. I tried your method, but it blew me out. I am going to try to modify it somemore to see if I can get anywhere.
>
>>Hello,
>>
>>Let's make sure I'm following you here. Are you saying you have an existing table structure, which contains all the fields in your SELECT statement, plus some additional ones?
>>
>>How about:
>>

>>*-- DUPLICATE ALL DATA INTO A SQL-STATEMENT FOR TRANSFER --*
>>SELECT a.inv_no,a.part_code,a.part_desc,b.mold_code,b.mat_code,a.part_qty,a.part_cost ;
>>    FROM order_items a, part_file b ;
>>    WHERE a.inv_no = cInvoiceNumber AND a.part_code=b.part_code ;
>>	INTO CURSOR MySqlCursor
>>select existingTable1  && I'm assume it is already open
>>append from dbf("mySqlCursor")
>>

>>