Printing a sheet of the same label

[picnichouse]

Hi,

Is there an easy way to get filemaker to print a sheet of the same label from the same field instead of moving to a new record for each label? For example, I want it to print the product name "Candy Apple" 30 times on the same sheet, formatted properly for Avery 5660 labels.

Thanks!

Andrew

[transpower]

This is easier in Word or WordPerfect. You could, though, make a global field with "Candy Apple", so that each record would have that for the label.

[treelily]

So are you saying, if i make all the fields on the label global, referencing actual fields from my record, (incorporating some calculation fields) I would be able to print up multiple copies of one record onto an Avery label?

Ideally, I was hoping to have my labels reference fields from my record that weren't global. Do you have a moment to go through this process?

[Ugo DI LUCA]

Search the Forums with "Avery" and you will find some answers for sure. This has been addressed before, even with a few samplers.

[spb]

The global field idea is great if you just want to quickly print a sheet of labels that says "Steve's Lunch Hands Off!" or something like that. If your labels are to have a bunch of normal fields on them, then the only way is to make a batch of duplicate records, one for each label. If you are printing thirty-up, isolate one record, make 29 duplicate records, and print.

You could script this, both making the dupes and deleting them after the fact. You could also embed those script steps into a loop, so if you wanted to print 30 labels each for a hundred records, it would isolate, dupe, print, delete extras one at a time for all hundred, and do it all with one button click.

I do a lot of labels and have too many variations of records and label-size to do it the way I've just described. I've found it easier to make a separate FM database containing all my label layouts. I import the records I need into this & manipulate them the way they need to be manipulated. When I'm done, I always delete all records, leaving the database empty for the next use.

But follow Ugo's suggestion. There are quite a few different ways to do the job. Next you might want to address the issue of printing on partial label sheets (also built into my separate label database).

Steve Brown

[Fenton]

Set a global to the record's unique ID. Have a self-relationship back to the ID.

Then use Merge fields, <<global relationship::regular field>>. That will be the same for all records.

Show/Omit records to get the number of labels you want. Doesn't really matter what records they are.

Use the self-relationship to return to the original record.

One problem is that the relationship names take up too much space. Fixes are: 1. Abbreviate the relationship name, and 2. Leave the first "<" the correct size, but select the rest of the merge field (<field>>) and size it to 2 pts. Best to magnify the screen while doing this.

Or use regular self-related fields. You don't really need Merge fields on a label, as they're not going to have page break problems.