>THANKS FOR YOUR QUICK ANSWER
>
>
>Chris, what do you mean when you say
>"Also, I try to avoid updating two tables in a view."?
I have had trouble in the past using an updateable view that combined data from two separate tables. For example, a paramterized view named rv_CustomerOrders that selects one Customer record and all their orders from the Orders table. When I tried to make the view updatable, updating both the Customer record and the Orders records, I ran into trouble.
That may be to my own experience.
Generally, I try to keep each of my updateable views limited to one table. For example, I will have a parameterized view named rv_Customer that selects one record from the Customer table, and another view named rv_Order that selects one record from the Order table, or rv_Orders (plural) that selects all orders for a customer.
If I need to look at Customers and Orders together, I will create a parameterized view named rv_CustomerOrder, where I combine the data, but I don't make the view updateable.
Chris McCandless
Red Sky Software