- Local time
- Today, 10:22
- Joined
- Feb 19, 2002
- Messages
- 45,073
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.
