I am trying to create a database with Product codes. Each product code is linked to a category (number). There are about 200 products and only 6 Categories.
Every month, I need to paste around 1000 records with Product Codes in a different database. This database needs to search if the Product Codes are linked to a Category Number.
The result should be 1000 records (which I paste) with the Product code next to it.
Any help would be very appreciated