Im trying to design a new databse. We receive a box of 1000 sequentially numbered bolts which we attach to individual customer containers, and sent out into the world. Im required to log the bolts in, which come into us in batches of 500 to 100, and go out as individuals.
I need to record the...