Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How I might avoid formatting nightmare

Status
Not open for further replies.

vbab

MIS
Oct 26, 2005
3
CA
I posted a related problem a week ago.
This one is a little different.

I have 3 units, called Parcel 1, Parcel 2, and Parcel 3. Each Parcel has a consignment size established by the user.
For example, Parcel 1 = 50,000.

Each Parcel can have up to 5 grades, called Grade 1, Grade 2, Grade 3, Grade 4, and Grade 5. The number of grades is established by the user. Each grade has a consignment size. For example, Parcel 1 may have only 2 grades with consignment sizes of 25,000 each.

The consignment size of each grade will determine the number of lots for each grade. For example, a consignment size of 25,000 may work out to 5 lots for each grade. (A mini program works out the size and number of lots per grade consignment size.)

In tabular form,

Parcel 1 (50,000)

Grade 1 (25,000)
Lot 1 6,000
Lot 2 6,000
Lot 3 6,000
Lot 4 6,000
Lot 5 1,000

Grade 2 (25,000)
Lot 1 6,000
Lot 2 6,000
Lot 3 6,000
Lot 4 6,000
Lot 5 1,000

The maximum number of Lots that any grade can have is 8.

What I need to figure out is how to print out a form for only those Lots with numbers in each Grade. For example, a consignment size of 25,000 works out to 5 Lots or 5 forms of a possible 8 Lots or 8 forms.

I would like the user to enter only the consignment sizes. The computer would then calculate the size and number of Lots for each grade and format the starting form for each grade. For example, if the user specified 2 Parcels at 10,000 each, with 2 grades per Parcel at 5,000 each, the computer would calculate size and number of Lots per Grade and format the first form for each Grade:

Parcel 1 (10,000)
Grade 1 (5,000)
Lot 1 1,000 <-- formatted and ready to print
Lot 2 1,000 (not yet formatted and ready to print)
Lot 3 1,000 (not yet formatted and ready to print)
Lot 4 1,000 (not yet formatted and ready to print)
Lot 5 1,000 (not yet formatted and ready to print)
Grade 2 (5,000)
(same as above)

Once the user pressed the print button, the program would print off the first formatted Lot. It would then erase the Lot 1 data, display the Lot 2 data on the same formatted sheet and print off that sheet. This would continue until all 5 Lots were printed off.

I was thinking that one print button would be good enough for all the grades in a Parcel. As soons as the last Lot of Grade 1 was printed off the program would move on to Grade 2, Lot 1, using the same formatted sheet.

Is this a realistic goal?
And if so, where would I start?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top