Hi
I am not sure if I need a separate query but will explain my problem. I have a linked table which contains all Sales Orders, the fields I am interested in are order_no, del_address, address3 and address5.
I have a form where the transport team enter the info regarding the loads they put on wagons i.e. order_no, no_of_plts etc. This forms can have multiple lines and populates a table called tbl_loads. tbl_loads also contains fields called del_address,address3 and address5.
What I would like to happen is either when the form has been fully filled in, del_address,address3 and address5 in the tbl_loads are populated based on the individual order numbers on the form i.e. if the form has three lines order x y z, I would want it to go to the table containing all sales orders, look up orders x y and z and populate del_address,address3 and address5 based on their value in the sales orders table.
Alternatively, I have created a update query, and said update tbl_loads.customer with customer from sales orders table, but it prompts me to enter a customer value.
In short, equivalent sql but in access for Update table1 set customer = A.customer from (select order_no,customer from tbl2)A where table1.order_no = A.order_no
Hope this makes sense, thank you for your time.