Hello everyone
I have 5 invoices , for example : Buy invoice , sale invoice , return invoice from customers , return invoice to the products and damage invoice )
Do I will make to each invoice special sub invoice in table and will make relationship between main invoice and sub invoice ?
Do I will enter ( date , and customers name in sub invoice too ) and will have also in main invoice too ?
for example : main invoice has ( invoice_ID , Date_Time , customers name , address , mobile , discount , total and notice ) and in sub invoice will has ( invoice_ID , Date_Time , customers name , Goods name , Quantity and Price ) , and When I make forms for this invoice I will make ( Hide, I mean unvisible ) for " Date_Time and customers name" in sub invoice .
And When I make a computational operations in Query for sub invoice ( Quantity * price ) Will I can to use it in subforms ?