Hi
I want to produce an invoice based on a number of tables.
The issue im having is that for each invoice there may be several "Order Details".
Order details consists of:
> Invoice Number
> Item Number
> Quantity
Each item corrosponding to each item number has a price.
Theefore how do I produce an invopice which calculates all of the "Order Details" corrosponding to that particular invoice number?
Hope that makes sense!
Thanks
WB
I want to produce an invoice based on a number of tables.
The issue im having is that for each invoice there may be several "Order Details".
Order details consists of:
> Invoice Number
> Item Number
> Quantity
Each item corrosponding to each item number has a price.
Theefore how do I produce an invopice which calculates all of the "Order Details" corrosponding to that particular invoice number?
Hope that makes sense!
Thanks
WB