application problem

[Bob Comeau]

A method of creating a variable number of records, one for each label
required
would be to link the subfile to another which is simply a list of sequential
numbers with one record for each number up to the maximum number of labels
you
care to produce. Then in the select statement include SELECT if
nbr-from-file <= nbr-labels-rqrd or some variation on the theme.

HTH
Bob Comeau

-----Original Message-----
From: owner-powerh-l@sphere.swau.edu
[mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Brown, Doug
Sent: Monday, November 20, 2000 3:55 AM
To: 'Powerh-l@sphere.swau.edu'
Cc: 'Hasse, Christina'
Subject: RE: application problem


Hi

You could create some "dynamic quiz" with a code something like:

	define xx char*80 = "set report limit " + ascii(qty)

	report xx skip "go"

	set subfile name xyz nodictionary

then in the next pass

	access & report statements
then
	use xyz

this would then run the report for each product selected in the first pass.
I assume that you are linking in such a way that the report limit will have
the desired effect of generating the required number of labels.

Regards
Douglas Brown
.____________________________________
|          work: +44(0)1689 89-5105
|        mobile: +44(0)7710 71-6147
| fax/voicemail: +44(0)870 168-3769
|    web e-mail: Mailto:dgb@fsmail.net
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.