Printing Labels - help!

[SteveGriff]

Hi people,

I've got a trivial problem to solve regarding the printing of labels. I've created a labels layout using the "new layout" labels wizard and the following relationship setup to print out labels of only one supplier: -

gSupplier_ID = Supplier_ID

You choose the supplier you want from a dropdown list that is using the gSupplier_ID field. This is a self relationship that allows me to print as many labels as I need regarding one supplier. The problem that I am getting is when I preview the print out, it previews 16 or so pages, relating to how many records I have in that database. (i.e - I have 128 records in my database... 128 / 8 labels on each page = 16)

What I'm trying to do is to get it so that only 1 page is printed out, i.e - 8 labels (on one page of A4). So I guess I have to try to fool Filemaker into searching for 8 records? That surely isn't the answer.

Any help on solving this problem would be great!

Thanxs

Steve Griff

[LiveOak]

You other option is not to use the automated label setup and manually create a one page form with eight sets of your fields. Then you print "current record" and select as many sheets as you wish in the print dialog. You will, of course, have to manually locate the fields on the form to match with the label positions.

-bd

[Mark Appleby]

I had terrible problems creating labels but finally set something very satisfactory up.

Create a new database called Labels and join it to the suppliers Database by the Supplier ID field. Create your label in this database.

Then create a field stating the number of labels to print ( if you normally print 8 set this number up as your default).

Finally create a button that and script that creates the lables and tells the computer to print them.

The script should run as follows (You will need to change it for your own situation)

>>Perform Find- Find labels to be printed where quantity to print >1

>> Loop

>>If quantity to print is >1

>>Set field to Quantity to print -1

>>Duplicate record

>>Set field Quantity to print,1

>>End If

>>Perform find- find tags to be printed Where quantity of tags to be printed is >1

>>Exit loop if [status Current found count]=0

>> Go to record first

>>End loop

>> Show all records

>> Go to layout Labels

>> Print

I would set something up to delete all records once they are printed from the labels database.