Jim,
You could use a while loop to accomplish that task. The while loop may be in the execution section of a Declare cursor. Use the cursor to pull up each line item of the order including the line item quantity. When you enter the while loop set a VAR such as vQTY = to the quantity of the line item and use the quantity field in the line item to construct the while loop (While vQTY > 0 ... endwhile). The while loop would contain an insert command and a SET VAR = (vQTY -1). The while loop would produce a quantity of records in the temporary table equal to the line item quantity in the order. Go to the RBASE help an read about While/Endwhile before you start. John From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, December 21, 2009 8:20 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: shipping labels John, If I go your route, I would still have turn the one row with four pieces (row 3) into four rows. I had thought of that. What code would I use to accomplish that? IF pieces > 1 THEN ? Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of John Engwer Sent: Monday, December 21, 2009 7:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: shipping labels Jim, One way to achieved the results you are looking for is to first build a temporary table containing one row of data for each label. The table should contain a column for every item of data that you want to appear on the label plus one auto number column. The auto number column would be used to identify the label as 1 of 6 etc. Then use label designer to produce the labels based on the temporary table. JOhn From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, December 21, 2009 7:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - shipping labels Presently our Bill of lading program prints labels in this manner. Let's say I have three rows of data for a bill of lading as below. Pieces Wgt/pc total Wgt Row one: 1 346 346 Row two: 1 845 845 Row three: 4 400 1600 The Program will print 6 labels; one each for the first two rows and four for the third line. Each label will show 1 of 6, 2 of 6, etc. and the weight as such 1 of 6 wgt 346 2 of 6 wgt 845 3 of 6 wgt 400 4 of 6 wgt 400 5 of 6 wgt 400 6 of 6 wgt 400 What function or command would I use to duplicate this process? Jim
