I have parts bins with 5 bins across and 10 rows down
I take it this has nothing to do with your table - it's the bin layout. Then what about
tblBins |
|
|
|
tblComp |
|
BinIDPK |
RowNO |
ColNO |
|
BinIDFK |
CompNO |
1 |
1 |
1 |
|
1 |
1 |
2 |
1 |
2 |
|
1 |
2 |
3 |
1 |
3 |
|
1 |
3 |
4 |
1 |
4 |
|
1 |
4 |
5 |
1 |
5 |
|
5 |
1 |
6 |
2 |
1 |
|
5 |
2 |
7 |
2 |
2 |
|
5 |
3 |
8 |
2 |
3 |
|
8 |
1 |
9 |
2 |
4 |
|
8 |
2 |
10 |
2 |
5 |
|
|
|
11 |
3 |
1 |
|
|
|
12 |
3 |
2 |
|
|
|
13 |
3 |
3 |
|
|
|
14 |
3 |
4 |
|
|
|
… |
… |
... |
|
|
|
46 |
10 |
1 |
|
|
|
47 |
10 |
2 |
|
|
|
48 |
10 |
3 |
|
|
|
49 |
10 |
4 |
|
|
|
50 |
10 |
5 |
|
|
|
Note that bins 2,3,4 have no compartments. 1 has 4; 5 has 3; 8 has 2. Bin 11 is in row 3, column 1. If you modify a bin to add/delete compartments, update the compartment table.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.