You opinion: Where should I add Tax field
I have a project involving two tables: Order and Order Detail (one-many
relationship). I am pondering where should I add the tax fields. Two
designs come to mind:
1. add two fields(tax[logic], taxtotal[numerica]) in Order table
2. If the order required to pay tax(non-government), A productID says
(0) will be added to the order detail table.
Which method should I use?? Or you have a better idea???