>>This workes fine except I just noticed that when I add new records to the table they are not showing up in the indexes. I don't understand.
>>
>
>Terry, this sounds like a FoxPro bug (5.0) that I ran into.
>
>In my situation I opened the table in the default session as NOUPDATE. Then I used a form with a private datasession to update the table. The changes were saved to the DBF file but the CDX file was not updated.
>
>I solved my problem by removing the NOUPDATE option from the USE statement in the default DS.
>
>HTH
>
>Peter

I was able to do some more research on this after I sent my first letter. It seems to be something along the lines you are stating. I found some of my combos worked - refrencing the exact same maintenance form. So, I made every single property and method the same between one that did work and one that didn't - no effect. Then I changed the Read Only flag on my default data session ( your solution ). Some then worked but others still failed. I then examined the tables directly. Sure enough the data was there just not in the index and I noticed by cycling the Set deleted On/Off I could get the data to appear and disappear. Finaly I packed and or reindexed the files and the data appeared fine. I can't do this in the production environment as it requires exclusive access to the file which by definition I don't have.
A this point I am again stuck.

Thanks
Terry