G
Gary Dolliver
Hi all,
is it possible to run an update on an unbound form and have it update a
table from another table which was recently updated? My code is as follows:
DoCmd.RunSQL "UPDATE Production_Shipments " & _
"SET Production_Shipments.Ship_Order_ID = Ship_Order.Ship_Order_ID " & _
"WHERE Production_Shipments.Item_ID = Ship_Order.Item_ID"
I am trying to insert a field in one table with a value from the other,
based on the Item_ID being similar. When I run the command, it brings up a
text box entry screen for me to enter in the values for both Ship_Order
fields (Ship_Order_ID and Item_ID), as if the table is not being looked at.
Is SQL the wrong way to approach this? How can I get the other table to be
viewed so I can update the other?
Help!
-gary
is it possible to run an update on an unbound form and have it update a
table from another table which was recently updated? My code is as follows:
DoCmd.RunSQL "UPDATE Production_Shipments " & _
"SET Production_Shipments.Ship_Order_ID = Ship_Order.Ship_Order_ID " & _
"WHERE Production_Shipments.Item_ID = Ship_Order.Item_ID"
I am trying to insert a field in one table with a value from the other,
based on the Item_ID being similar. When I run the command, it brings up a
text box entry screen for me to enter in the values for both Ship_Order
fields (Ship_Order_ID and Item_ID), as if the table is not being looked at.
Is SQL the wrong way to approach this? How can I get the other table to be
viewed so I can update the other?
Help!
-gary