Level 51
If they have the same data, why would you split them?
Anyway, that type of questions doesn't have a right answer. Just do what you fits your project well.
1 like
Feb 19, 2022
1
Level 1
invoices table structure
I am building an invoice system and I would like to should I separate the expense from the income or should I build one table gathering them together with status to differentiate.
take into account that I am going to have a pivot table that will link the invoice table with 2 different table income items and expenses items depending on invoice type (income or expenses)
Please or to participate in this conversation.