Appending records

[Guest_imported]

I have an orders table that has customer name, delivery details, order number, etc and a field that has number of pallets for that order. A label report is then created from this printing out the customer order details.

At the moment, the report prints out 1 page per Customer / Order number. If the number of pallets is greater than 1 in an order, I have to copy that report for whatever number of pallets it has, ie. if the number of pallets for an order is 3, then I have to copy that report 2 more times.

I would like to be able to print out all the records in one go but if an order for example has 3 pallets in the no of pallets field, then the label prints out 3 times and says pallet 1 of 3 on the first one, pallet 2 of 3 on the second and pallet 3 of 3 on the third.

I dont know if it would be easier by having an append query write the records into a new table or just have VB code in the report that does something. Either way I don't mind but I have no idea how to do it.

Any help is greatly appreciated.

Thanks

Jim

 

[dpimental]

One way to solve your problem would be to create a "palets" table and enter a record for each palet. Each Palet would have an orderid, which would be related to the orders table.

So, you would produce a query that adds the orders table and the palets table, related by order id.

Then you group the records by order id, and print your report.

Your DataEntry form should have a Main Form and a SubForm.
The Main Form controls the Orders.
The Subform controls the palets.

That's what I think you'll want to do.

David I'm Your Huckleberry!

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is imported as a whole record from another database system as a whole record.

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is automatically imported from another database system as whole records.

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is automatically imported from another database system as whole records.

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is automatically imported from another database system as whole records.

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is automatically imported from another database system as whole records.

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is automatically imported from another database system as whole records.

 

[Guest_imported]

Thanks for the reply but I don't think that wouldn't be effective given that there are about 500+ orders a day. To input all that data into the table would be far more time consuming. The data is automatically imported from another database system as whole records.

 

[Guest_imported]

Didn't realise I was posting the same message. It kept saying error !