Handling a product with multiple barcodes

[samantham12]

I've built an inventory app that is handling our incoming stock of hardware e.g. Macs, accessories, etc

I've discovered that Apple in their wisdom has started changing the product barcode (Part No) on a regular basis even when the specification remains the same, so now I've encountered an issue where I now have up to 3 different products for one specification because they all have different barcodes.

What would be the best way (I have no idea how I got this app working frankly, I am dyslexic when it comes to coding) to ensure that additional barcodes can be referenced or 'added' to an existing product?

[Marc_Dillon · Accepted solution]

I'd probably just store them in an EnumList on the Product table itself.

Another option is a child table of Product_Barcodes, which references a Product , and associates a single barcode per record.