J
J
I am building a database to track products being made and when it comes to
the packaging portion I need some assistance. After parts are built, the
one's that pass inspection will be packaged into Lots which can contain a
maximum of X parts where X is determined by BatchType. The Lot is being
filled over time and as the part is assigned to the Lot it needs to be
time-stamped The Lots will then be assigned to Batches for shipping.
1. I can have a Batch form with a Parts subform
2. In order to qualify, a part cannot contain a value in any of the 3
FailCode fields so I can base my subform listboxon a query where TopInsp,
BotInsp,FnlInsp are Null ?
3. How can I limit the number of parts to X ?
4. Is there a way to make a continuous form that has 4 sections of
62+row-2columns instead of a loonnng 250 row/2 column form, or what would be
a better approach for the data entry?
thanks for the assistance and coding details are appreciated. I'm a novice.
the packaging portion I need some assistance. After parts are built, the
one's that pass inspection will be packaged into Lots which can contain a
maximum of X parts where X is determined by BatchType. The Lot is being
filled over time and as the part is assigned to the Lot it needs to be
time-stamped The Lots will then be assigned to Batches for shipping.
1. I can have a Batch form with a Parts subform
2. In order to qualify, a part cannot contain a value in any of the 3
FailCode fields so I can base my subform listboxon a query where TopInsp,
BotInsp,FnlInsp are Null ?
3. How can I limit the number of parts to X ?
4. Is there a way to make a continuous form that has 4 sections of
62+row-2columns instead of a loonnng 250 row/2 column form, or what would be
a better approach for the data entry?
thanks for the assistance and coding details are appreciated. I'm a novice.