Update a column

[Hum Dum]

I want to update a column of one table A with column of another table B. for one entry of A, B contains 2 or more entry. Say A is super table of B. I wrote a query like this

UPDATE SendSet SET oDate = (Select oOrder.oDate from oOrder where oOrder.oID=SendSet.oID)
WHERE Exists (Select oOrder.oDate from oOrder where oOrder.oID=SendSet.oID);

DB is MS-Access. But it gives error : Operation must use an updatable query !! You attempted to run a query that tried to update a field that cannot be updated. For example, you may have created the query in such a way that you tried to update a field on the one side of a one-to-many relationship. any help ?

[loyal ginger]

You can use a join in your update query. Please check out how to do a join.

[loyal ginger]

Without knowing the relationship between table A and table B, I can only suggest that you use something like this:

update SendSet inner join oOrder on SendSet.oID=oOrder.oID set SendSet.oDate=oOrder.oDate;

You need to work out what exactly you need to do this update. Happy programming!

[Hum Dum]

Thanks. it works. regards :)