I have a database of invoice lines.
When a new batch of invoices is imported, I add additional fields to each record, such as product category.
I have a lookup table that contains each product description, together with it’s associated category.
After I’ve run an update query to add the categories to the new records, I then check for any blank category fields and if any are found, I add the new product description and category to the lookup table and rerun the update query.
I’ve noticed that my lookup table contains duplicated product description records i.e. when I’ve run an update, a product does not find a match in the lookup table – even though one is there.
I’ve checked for leading and/or trailing spaces in duplicated lookup table records and also checked the length of duplicated product descriptions and found nothing that would suggest why a match was not found.
Any ideas as to why this is happening?
Thanks