I need to update table1 with a field value from table2.
If both tables contain (among other fields)...
Table1 has the barcode value in it which needs to populate the equivilant field in table2 (when the names match).
Occasionaly we will need to run a query to do this. I have tried (in my newbie kind of why) to do this is several ways but can't seem to strike the 'right' way.
Can somebody point me in the right direction?