Hello,
I want to create a template for my Despatch Slip. The Data in this comes from 3 tables - DS, DO and DO_Items. Now , How do I get the data from all this and print in Hierarchial Format like below
Date: <>
DS_ID: <<DS_ID>>
Customer ID : <<Customer_ID>><<Order1.Id>> , <<Order1.Qty>> etc (From DO Table with ref of DS)
<<Order1Item1.Packets>> , <<Order1Item1.Sheets>> <<Order1Item2.Packets>> , <<Order1Item2.Sheets>>
<<Order2.Id>> , <<Order2.Qty>> etc (From DO Table with ref of DS)
<<Order2Item1.Packets>> , <<Order2Item1.Sheets>> <<Order2Item2.Packets>> , <<Order2Item2.Sheets>>
The number of orders and the number orderitems for each orders cannot be predefined as it keeps varying.
How do I do this ?
Thanks โฆ I have tried and it seems working.
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |