>I have a view that shows data from one table plus a look-up field from another table. I want to be able to delete a record from the main table without affecting the look-up table. How can I do this?
>
>Thanks,
>Elyse

As long as you have not made the lookup table part of the view updatable, all you need to do is delete the record in the view. When I include descriptive data from a lookup table in a view, the lookup table part of the view is never updatable. If you did not identify a key field for the lookup table, then that table does not get updated.