LuxCoder
August 12th, 2007, 09:08 AM
I have VB form named Booking where i can book Six items at once for a particular customer . 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
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 report in Details section as follows:
Order No: 2 Book Dt: 10-8-07 Delivery Dt: 14-8-07 Cust ID: 5
Quantity Item Sub - Item Rate Amount
1 Pant Formal 200.00 200.00
3 Shirt Readymade 150.00 450.00
2 Coat Single Breast 2200.00 4400.00
Total 5050.00
How can i do this ???
Please help !
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
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 report in Details section as follows:
Order No: 2 Book Dt: 10-8-07 Delivery Dt: 14-8-07 Cust ID: 5
Quantity Item Sub - Item Rate Amount
1 Pant Formal 200.00 200.00
3 Shirt Readymade 150.00 450.00
2 Coat Single Breast 2200.00 4400.00
Total 5050.00
How can i do this ???
Please help !