>Hi Mr Bereznikler
>
>Thanks for your answer Set deleted ON really works on views, but my issue is a little diferent and I will try to explain you.
>
>I have 2 tables Orders and Order_items with them and others I manage the Ordering process in my application. However the user can delete one or more items of the order, in the form I use set deleted on to filter and works ok. In order to print the order document I use a local view to join all needed fields but if I use Deleted() in the view property it filter the deleted order items and his respective parents too. I only need to filter the records marked in the order_items.
>
>May be the solution is in the filter conditions of the view designer, but i don't know how to do.
You shouldn't rely on the fact that in VFP deleted records not physicaly deleted because it doesn't work this way for other backends. IOW, if record is deleted you should consider it not existing anymore. You should add some other field to the order_items table that will indicate the record status and use it as a filter in your view.
--sb--