What I am trying to do is easily done in microsoft Access using an update query. I want to update a field in one table/dbf with the same field in another/joined table/dbf.
Example. I have a table (Table A) with PartNumber, Desc, Manufacturer, Vendor, Cost, RetailPrice, Deptarment, and...