Hi,
I would appreciate all and any solutions to my question.
I have a table Order_Detail and a table Products.
Order_Detail

(Order_Id Char(20),
Prod_Id Char(20),
Qty...etc )

Products
(
Prod_Id Char(20),
Name Char(20),
Price...etc)


Now I have a ADODC which selects
Select Order_ID, Order_detail.Prod_ID, Products.Name...
Etc
From Order_Detail, Products
Where Order_Detail.Prod_Id = Products.Prod_Id
And Order_Detail.Order_Id = 1 ( or whatever )

There is a DBGRID which uses this adodc to populate.
Populates Fine !

( This is updatable)
But when I try to update not only does it try to update
the Order_detail (which is intentional ) but also it tries
to insert/update into Products (which I dont want)

How do I prevent this from happening,

Does anybody knows any solution in this situation ?

Thanks in anticipation


.