this should be so simple.... HELP

[pigpants]

I'm trying to create shipping labels that would return a running count.

The user would enter number of boxes, then the labels would return a count for each label.

i.e.: 10 boxes would return a "1 of 10", "2 of 10", etc. etc. for each label.

I'm a bit of a novice, so any help is GREATLY appreciated.

thanks,

Michael

[danjacoby]

You could create a script that temporarily creates new records for shipping purposes:

First, create a "LabelNo" field that returns a number, and have it auto-enter a "1". Now create a global field ("gLabelNo") that returns a number. Finally, create a calc field, "ShippingLabelInfo", with the following calc:

LabelNo & " of " & BoxesNo

(Note the spaces on either side of the word "if")

Finally, perform a find for all records where LabelNo > 1 (yeah, you might want to create a phony record first).

Now the script (BTW, I'm calling the field where the number of boxes is entered "BoxesNo"):

Show All

Omit Record

Show Omitted

(So far, we've set things up to be just the current record)

If BoxesNo > 1

Set Field (gLabelNo, 2)

Loop

EndLoopIf (LabelNo = BoxesNo)

Duplicate Record

Set Field (LabelNo, gLabelNo)

Set Field (gLabelNo, LabelNo + 1)

End Loop

(Now we have one record for each label)

Print

Perform Find (Restore, Replace Found Set)

Delete All Records (No Dialog)

[pigpants]

Worked like a CHARM.

I really can't thank you enough for your help, it is MUCH MUCH MUCH appreciated!!!!!

thanks!

-Michael

[danjacoby]

That's why I get the big bucks.

$75/hr., actually.