>I read through the thread and looked at what the others have said. First, your primary keys should be absolutely unique. That is the definition of a primary key. There is no reason the user needs to see it. If you need information on creating them, look at my web site.

I use integer IDs as primary indexes in this application. They are unique.

>
>Second, by filtering your index tags you are basically turning off Rushmore. Again, there is an article on my web site.


I am aware of that. These are just lookup tables for County, Employment status, etc. Rushmore is not an issue here.

>
>Third, you should use the FLUSH command after every update (add, edit, and delete). It will make sure that the buffers on the workstation are flushed to the server.

I will try the flush. The data is getting to the table though. It is just not getting to the CDX.

>
>Finally, make sure that ALL write buffering on the server's hard drives is turned off.


I will check the server. I don't remember turning it on though. It may be a default in NT server. If VFP applications require special settings on NT Server I classify this as a bug as servers should not have to be ajusted to distribute applications. Falls allong the touchy lines of HP printer drivers ...


Thanks for the help

Terry