Yes, when someone enters the Vendor & product in the local table I want the department to automatically update the department field and store the data in the local record. All records are in the ODBC db (and in some instances there are multiple products with different vendors so I need to meet...