Printing multiple labels based on a quantity field

[jwnacnud]

I am finishing up a purchase order program for our store. The purchase order has many fields, the pertinent ones are: Model Number, QTY, Description, Cost, Sell price

on any given purchase order we order over 20 line items, with different quantities for each.

I need to be able to print a label for each item:

3 for item 1, 6 for item 2, 1 for item 1...... based on the quantity field.

any ideas?

I can be contacted via email as well: [email protected]

Thank you.

Jeffrey Duncan

[rivet]

I used repeat fields for a similar situation.

When you import a record with repeat fields all field that are not repeating will duplicate.

so just add a repeat field in your line item table that will calc out the quantity. So if you have a quantity of 6 the first six repeating lines will have a value of 1.

now import the line items into a tag table and the repeat field will burst into individual records.

[jwnacnud]

Thank you for you help. I can't see how to create a repeating field that caclulates out the quantity. Can you help on this? I think i understand the rest.

[rivet]

see attached

repeat.zip