A
accessuser1308
My database consists of tables forms for storage/shipping of wine bottles in
wooden boxes/crates. My crates are divided into 25 wells where a bottle of
wine may be placed. I store my crates on shelving units. I do not want to
create a form/table that has 25 different text fields for recording the wine
in a crate. I would like a single text field where I can apply its location
to.
I have a form that will ask me the starting location for entering new wine
bottles. This form will ask for (in this order) ShelvingUnit, Shelf,
CrateID, Row, Column. ShelvingUnit is and text field that will contain a
letter A-D (4 units). Shelf is a text field that will contain letters AA-EE
(5 shelves). CrateID is a number 100-infinity (a new crateid is added every
time a new crate is started. Row is text A-E (5 Rows). Colum is numeric 1-5
(5 columns). If I enter a starting location of Unit B, ShelfAA, Crate 101,
Row E, Column 5 I would like the second entry to automatically be Unit B,
ShelfAA, Crate 102 (because 101 was filled), Row A, Column 1. Thus, like to
program my entry form such that it will start with the location specified.
It will then increment column number until it has entered number 5. It will
then start back at 1, but the Row will increment to the next letter, until it
has entered E. Row will then start back at A and crateid will be incremented
to the next number, until the crate is full (E5 row-column)….and so on,
incrementing each higher unit when the lower unit has been filled.
Please let me know if this made no sense.
Thank you
wooden boxes/crates. My crates are divided into 25 wells where a bottle of
wine may be placed. I store my crates on shelving units. I do not want to
create a form/table that has 25 different text fields for recording the wine
in a crate. I would like a single text field where I can apply its location
to.
I have a form that will ask me the starting location for entering new wine
bottles. This form will ask for (in this order) ShelvingUnit, Shelf,
CrateID, Row, Column. ShelvingUnit is and text field that will contain a
letter A-D (4 units). Shelf is a text field that will contain letters AA-EE
(5 shelves). CrateID is a number 100-infinity (a new crateid is added every
time a new crate is started. Row is text A-E (5 Rows). Colum is numeric 1-5
(5 columns). If I enter a starting location of Unit B, ShelfAA, Crate 101,
Row E, Column 5 I would like the second entry to automatically be Unit B,
ShelfAA, Crate 102 (because 101 was filled), Row A, Column 1. Thus, like to
program my entry form such that it will start with the location specified.
It will then increment column number until it has entered number 5. It will
then start back at 1, but the Row will increment to the next letter, until it
has entered E. Row will then start back at A and crateid will be incremented
to the next number, until the crate is full (E5 row-column)….and so on,
incrementing each higher unit when the lower unit has been filled.
Please let me know if this made no sense.
Thank you