AnsweredAssumed Answered

How do you create multiple discrete records based on a quantity field

Question asked by roughler on Jun 11, 2012
Latest reply on Jul 12, 2012 by roughler

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.

Outcomes