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?

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?


On Apr 17, 10:16 am, learningaccess
<learningacc...@discussions.microsoft.com> wrote:
> 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?