>>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.

I don't want the lookup table to be updatable, but I'm getting an error implying that it's trying to update that table as well. I didn't specify a key field. How can I specify which table gets updated?