Hi Dmitry

I am a very new developer to FoxPro, but I did encounter a "similiar" problem that you are having a month ago. I set up my "getkey" program to auto-generate primary keys. When I finished and I tried to APPEND (not pack as in your case) a new record, I received the error message "Data Type Mismatch".

In my case, it had nothing to do with validation, indexes, default values, etc. It simply had to do with the DATA TYPE in my keylist table not "matching" the data type in the related fields of my tables.

For instance. In my keylist table, my keynum field was set to NUMERIC, however, in my tables that my keylist table was communicating with to handle my primary keys, I had my join field set to CHARACTER. It wouldn't let me do anything. I would keep getting the error message you are getting.

So, my advice would be to go back and make sure that all your joins, whether they be your auto-key join, etc. are matched. The thing to focus on would be the data type.

I hope this was a little helpful. I wish I could help you further, but I am just a beginner!

Jason