>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