Hello all,
I still haven't got a good grasp on queries. I want to update some empty fields in a table based on the value of another field in the same table. In the attached file there are 2 tables, Copy of Inventory Transactions and tblPartMain. Essentially I want to find every row where "PartNum" is empty in "Copy of Inventory Transactions" and fill it with "MfrPartNumber" from "tblPartMain".
I started a query (query1) but I don't know how, using the builder, to get the info from "tblPartMain" into the update field.
Am I missing something in the query builder because no expression categories are aviable to select?
Thanks
Dave
TransTable.zip