>>>>>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
>>
>>Eric,
>>
>>Maybe I'm not understanding your original question. You have a view based on two tables (related?) and want to know if you can deleted the record in the table(s) through the view? I do this using Table-level Buffering, cascading deletes and nested TableUpdates. For me, views and Buffering go hand-in-hand.
>>
>>Renoir
>
>
>Renoir,
>
>I am just new to the game and still trying to formulate the big picture, I think you understand what I am making reference to.

Ahhh... Now I understand. Unfortunately I have to leave right now, but if someone else hasn't given you detailed steps regarding doing this, then I'll do so myself in the morning. Sorry for not understanding...

Renoir