Microsoft Access Expert 22

Microsoft Access Expert 22
By Richard Rost

8 years ago

Unique product IDs Upload Images Link
B
8 years ago

Great class Rick. Here's a question (using the class' updating vendor pricing as an example)-what do you do if the vendor's product codes aren't unique enough for you? For example, you have two vendors, and they both have a product 003, and you don't want to manually tweak the spreadsheet to include your autonumber for the product id etc. To solve this, I've been using a concatenation for the product id (for example, their product code concatenated with the company id). Is there a better way?

Reply from Richard Rost:

This is why I recommend having a separate import for each vendor's price updates. They're likely going to have different fields or field names. Unless they're EXACTLY the same and using something universal like a UPC code, then this is probably the best solution for you. Perhaps eventually everyone will get onboard with the same XML-based data set (at least for your business) but until that day it's best to have separate imports, IMHO.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Microsoft Access Expert 22 Comments