Append query, multiple tables
I am wondering if I can take data from table Sheet1 and append it to table ItemLocations, using the MasterNumber as a flag/link for the records.
BinText is simply the textual location identifier, ie: WH1 A A1 (warehouse, isle, section, shelf)
I imported and manipulated the data from Excel to create Sheet1, and would rather not enter each record manually, as there are about 3000. I already had to do that for vendor part numbers - because the old system uses the Master number as a PK of sorts, but that does not work with this system.
See attached picture for tables.
Life is not a problem to be solved, but a reality to experience.