I have a location table where a user creates a new record, selects a location and enters the number of labels she would like. Then she creates another new records and selects a different location and the number of labels needed etc... When finished she wants to print the appropriate number of labels for each location.

I've created a label table and in that table and I'm trying to write a script that will create all the labels for all locations.

I've created a script that is able to create 1 label but I am not a proficient enough scripter to figure out how to write it so that it creates all the labels.

Any assistance is greatly appreciated.

I have attached a sample database.

quicklabels.zip

See if this helps:

http://fmforums.com/forum/topic/42423-creating-small-label-printing-database/#entry197906

Thanks. I had no idea you could use a repeating field along with an export / import to create new records.