[RESOLVED] Combining multible table fields to one report

[LuxCoder]

I have VB form named Booking where i can book Six items at once for a particular customer [Refer attached File2.]. Now these booking details gets stored in BookingMaster database table according to the following fields:

Order Number
Customer ID
Booking date
Delivery date
Quantity
Item
Sub Item
Rate

For every item booked a new record is created according to the aforementioned fields. For example OrderNo: 2 has three items booked (Pant, Shirt & Coat). The booking in the database will be like this:

Order Number : 2
Customer ID : 5
Booking date : 10-8-07
Delivery date : 14-8-07
Quantity : 1
Item : Pant
Sub Item : Formal
Rate : 200.00


Order Number : 2
Customer ID : 5
Booking date : 10-8-07
Delivery date : 14-8-07
Quantity : 3
Item : Shirt
Sub Item : Readymade
Rate : 150.00


Order Number : 2
Customer ID : 5
Booking date : 10-8-07
Delivery date : 14-8-07
Quantity : 2
Item : Coat
Sub Item : Single Breast
Rate : 2200.00

I hope you got the picture. Now while printing Booking Form i want to select Quantity,Item,Sub Item & Rate from all the records where Order Number = 2 and print it in the same form [Refer Attached File1]. How can i do this ???
Please help !

[LuxCoder]

Is this possible ??? Please help !