>>>Hello Everyone,
>>>
>>>Is it possible to delete a record through a view. I have a form that has a grid on it based on a view. I am using a view as the record source because one table has only customer info while the other has only purchased product info and it is really helpful to see fields from both tables when deciding which record to delete. If there is a better method I would like to know or please provide possible syntax.
>>
>>Eric,
>>
>>Yes. With Buffering you can delete records and then TableUpdate to commit the change to the base table.
>>
>>Renoir
>
>Renoir,
>
>Could you explain why is it important to use buffering when the records come from a view.
>
>Thanks...Eric
I think it is best to use buffering, whether you work with a table or with a view. Buffering makes it relatively easy to undo changes, or save them, depending on the user's desire, or other conditions.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)