I thought this would be easy but am having no success...
I have a simple flat inventory database which includes a quantity field, for instance I have 9 widgets in stock.
I now want to give each widget a unique indentification.
How can I create a script that will look at the amount in the quantity field and create an equivalent number of discrete records - resetting the quantity in the original record to 1.
Then loop this script through a around 3000 records (only about 400 have a quantity greater than 1)
I always appreciate help - I need lots.