I have a dB set up for my all of my clients. Each time they order a product, I can print off a label for each record. Now, suppose they order 19 units and I have to print off 1 label for each unit. Now, suppose I have 20 different people that all need 19 units. I would like to be able to enter in a quantity of units for a certain group of clients and have FM print off the number of labels that I need.

Is there a way to ask FM to copy a record (client info) into a new dB, then duplicate it as many times as I need? Then, do the same for the remaining people. In theory, this new dB would only contain all of the records I would need for this round of shipping (assuming that 1 record = 1 label)

This sound confusing but its the only way that I can explain it!!

Thanks for your help!

Hi there,

You could do this in several ways; one way would be to script your printcommand and have it inside a loop that loops for the amount of labels that you want to print.

Assuming 1. your clients list also has a field where you enter the amount of labels that need to be printed for that client you could do this with two scripts like:

First script (loops through the list of clients)

goto record [first]

loop

perform script [second script]

goto record [next, exit after last]

end loop

Second script (prints the desired amount of labels for that client)

loop

exit loop if [ AmountOfLabels = 0 ]

print

set AmountOfLabels [ AmountOfLabels - 1 ]

end loop

But as I said, there are much more ways to achieve this. Hope the explanation and pseudo script is understandable.

Regards,

Ernst.