>>>>>>If memo fields are involved, did you remember to use the MEMO keyword?
>>>>>
>>>>>There is no memo fields.
>>>>>
>>>>>Thanks for the interest.
>>>>
>>>>Are you sure that these fields that can't be saved are spelled equally in both tables?
>>>
>>>Checked agan, and definitely.
>>
>>Can you name some of the missing fields, and their type?
>
>I found the problem. The store queries its table into a temporary free table. The table is sent to the Home Office. But now the table is free, and the field name longer then 10 have been truncated to 10. When it arrives at the home office and it attempts to insert into the table, the field names for those truncated don't match. I know how to fix it. Thanks all for making think outside the box.

I suspected something like that, which is why I asked for the actual field names. Personally I never use long field names, because I know they wil bite me sooner or later. :-)