Only allowing incremented Data

[Guest]

I have a database that i use to maintain information about given parts within
different Lot numbers. For example, one Lot of parts will be issued that has
10 individual part numbers within that given Lot. I would like the ability to
require that the next part number entered is the next number in that series.

To be more clear:

Say I have issued a Lot of parts (1-10) and that given Lot is the 3rd Lot in
a set of Lots:

Lot3Part1
Lot3Part2
Lot3Part3
etc.

When users are inputing the information about these parts, i do not want
them to be able to enter the info about Lot3Part3 without first having input
the info about Lot3Part2.

I hope this makes sense, can anyone help me?

 

[Ryan Clair]

Depending how you want the tables set up.... I'd have 2 columns, one
for the Lot number and one for the Part number (you'd probably want
it's own table). If it's an old Lot, new Part: query from the form for
the Lot number and LAST Part number and add one to it in the form's
code. If it's a new Lot number, query for the LAST Lot number + 1 in
the form and default Part to 1.

Make sense?

 

[Guest]

We already have the part information identified on a barcode label so the
database just reads the barcode and inputs that data into a table. I am
actually looking for a way to accept or decline a scanned barcode based on
whether or not it is the next number in a series.

Does that make sense?