I get asked this question quite often: how do you track specific units in your product database without duplicating a lot of information. The answer: create two tables. This tutorial explains how:

/tips/access/inventory-parts-and-units

In the inventory section of my Access classes (320-series) I didn't go into tracking specific units in great detail. I just showed you how to track product types with quantity levels (I have 30 keyboards on the shelf).

This tutorial will show you what to do if you want to actually track each specific keyboard with a barcode, for example.

Barcode Scanner Upload Images   Link   Richard Rost  13 years ago I've added "Using Access with a Barcode Scanner" to the WAITING LIST under the "Other New Seminars" section. If you're interested in seeing how to do this, VOTE for this seminar on the Waiting List. If I get 4 or 5 people who are interested, I'll record the seminar. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.