Order Summary Report

[ryonker]

Good afternoon. I am trying to figure out how to create an order summary or packing slip style report. I have an order number that the information will be sorted on and I need to list all items purchased under that unique order number. Each order number can have multiple items and each item is entered individually. I have been unable to find a way to do this. This report will also be printed out on a preprinted form. I have been unable to get the some of the fields to remain in the same spot. If they move then it will throw off the alignment with the form itself. Can anyone help?



Thanks,
Robert

[ajetrumpet]

have you googled this, robert?

I would bet there is software out there to do this sort of alignment, but not 100% sure. as far as getting the data ON the report, have you tried using a query to enjoin the right and left tables, and simply displaying it that way?

or, how about a main rpt and a sub, with the sub listing the continuous entries for the order? an autoreport from the left table should generate the layout automatically if you want to see it.