>the item code is located in TABLE A (ar_codes)
>the ONLY field in this table is item_codes
>
>TABLE B is created from a cursor that holds an invoice description,
>the first portion of the invoice description is the invoice number.
>Bascially, the invoice description is a reference to a credit.
>
>TABLE C is the actual current order file where as TABLE D is an archived order file.
>


OK, so how does tableA join to any other table if none of the others have Item_code in them? How does Fox know which record in tableB is supposed to be combined with a record in TableA? Your problem seems to be that Item_code is ONLY in tableA and not in any of the other tables you are trying to process.