asked on

MS-ACCESS assigning and managing product IDs

Hi

My supplier sends me a monthly product list which I manage in MS-ACCESS

I want to assign an identifier to each product in the supplier's product list

How can I preserve and extend this ID assignment, in MS-ACCESS, when I will receive next month's product list ?

thanks
yann

ASKER CERTIFIED SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

OddyWriter

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Samuel Shon

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

John Tsioumpris

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim Dettman (EE MVE)

John made an very important point with his comment; you must do this for each supplier, so you must include the supplier ID you use for that supplier as you might have two different suppliers using the same part number.

So you need:

SupplierID - who is this for
TheirItemNumber - what is their part number
OurItemNumber - Our item number for this

supplier their # Our #
ABC 1234 Widget
XYZ 1234 Bolt, hardened steel

This is not uncommon in systems where you keep track of a customer or vendors part numbers in your system, and you may tie a lot of different things to this like pricing, placement of PO's, etc. Also note two other things:

1. It is also not uncommon for you to have multiple entries that cross reference to the same item for you, and you need to allow for that.
2. Make sure you use a text field for their item number at the very least. You never can tell what a vendor may use for their numbering system.

Jim.