Currently I have two tables: -one containing a list of items and a supplier number for said item -one containing a list of supplier numbers and a name for said number.
I am trying to update the first table to add the supplier name to each entry where the supplier numbers from each form match up.