Hello everyone
Which way is better to build a tables for Invoices ?
for example :
We have 6 Invoices (Sale Invoice , Return Sale Invoice , Purchase Invoice , Return Purchase Invoice , Stock Invoice and Surplus Invoice )
each table is independent , it means every table has a special details with a special sub table : in this way we will have 6 head tables with 6 sub table
or we use another way is better
one table for head table and one for sub table , and make relationship between them .