Hello

I have a question about views.
Since views are updateable, I wanted to know a few things about views.

I have a Orders table

nOrderNo
cCustomer

I have a OrderDetails table

nOrderNo
cItem
nQty

I have a updateable view with the sql like this ..

Select Orders.*,OrderDetails.* from Orders Left Join OrderDetails on Orders.nOrderNo = OrderDetails.nOrderNo

Now if I append a record to this view what all is happening internally ?

I need some very good documentation on views.

Any sugestions ?

Thanx in advance .