Duplicate Records based upon Field Value

[kcid]

I need to duplicate a record a number of times based upon a value in the record (Quantity).

There may be 12 records imported, three of which may have a quantity greater than 1.

I need to make duplicates of the records with a quantity greater than 1 so I end up with enough copies to equal the original quantity.

I hope that makes sense.

[comment]

What's the purpose of the duplicates?

[kcid]

When purchasing equipment, they will order:

4 Widgets 135.00 540.00 total

But need to track them individually in the file in question (serial number, location, service history, etc.).

Since the purchase volume is somewhat high, it is not practical (or desirable) to duplicate the needed records by hand.

If they had the money it would be great to integrate the two systems, but that will never happen. This department is simply trying to get a handle on their inventory which is scattered far and wide. So when purchasing/receiving sends them a file (usually excel) saying they are getting X number of these, they need to create a record for each, individual item.

I have found a way to do this, but it seems far to convoluted, and I am sure some of the great people on this forum have a simple, elegant answer.

[comment]

I think I would prefer to create a record for each ordered item in a separate table.

The method could be very similar to the one here:

http://www.fmforums.com/forum/showtopic.php?tid/176171/post/203220/#203220

only simpler (since you don't need to skip anything).