Yep, did that already. All fields are marked as updateable.

By the way, visited your site and really enjoyed the humor.



>>Thanks! The select statement works, then I just check _TALLY to see if it was found.
>>
>>How about this; when I add a record to the buffer, and then issue an SQLCOMMIT, Foxpro updates the remote table but LOSES my key field. It is now 0 in the remote table. I can see the correct value in my cursor, I issue the SQLCOMMIT, close the cursor, reopen it, and the key value is 0. Of course, the next time, it won't COMMIT, as there is already a 0 there.
>>
>>Anyone?
>
>Perhaps it is because Fox doesn't make keys automatically updateable? I know that in the view designer, you have to explicitly set key values to updatable. Even 'Update All' will not update keys.
>
>HTH,
>Scot.