- Local time
- Yesterday, 22:33
- Joined
- Feb 19, 2002
- Messages
- 44,815
There is a method of generating x records using what is frequently called a "tally table". This table has rows with values from 1 to x with x being the maximum number of items you will need to generate. This particular example is from a receiving/shipping application I built for a client. The warehouse wanted to enter the item type and a quantity and have x individual inventory items generated. So, they received "White Sheets", "10 cases" and White Sheets with box numbers 1-10 were generated. This allowed the pickers to ship specific boxes to ensure that inventory didn't get stale.
