You are welcome.
** dancing on the table** I beat Sergey, I beat Sergey - lol :-)

>Thanks, that was it. I did not notice it was missing untill you mentioned it.
>
>>Hi Claude,
>>
>> don't you need to do a tableupdate if the table is in a private datasession?
>>
>>HTH
>>Beth
>>>VFP 9
>>>
>>>I have a form with the following code
>>>

>>>SELECT pireq
>>>DELETE FROM pireq WHERE creqno = lcreqno
>>>BROWSE
>>>SELECT piitems
>>>DELETE FROM piitems WHERE creqno = lcreqno
>>>BROWSE  	
>>>

>>>when browing the tables from within the form method the records are marked as deleded, but when I view the same records from the "data" tab of the project manager they are not marked as deleted.
>>>
>>>The dataenviorment is set to private and optomistic. For the tables I have bufferoveride set to optomistic and a filter, and an order set.
>>>
>>>Why? Any help appreicatied.