Joined: 11 Aug 2007
Online Status: Offline
Posts: 1
Topic: Combining multible table fields to one report Posted: 12 Aug 2007 at 2:17am
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged