Hi,
Thank you.
Yes, I am designing as what you suggested. I have a problem there, I still not clear, how should I differentiate the invoice, sales and etc records will collected from branches to office. Do I need to add a prefix for every transaction, and have a branches table which store the branch details with the prefixes used in all records?
Thankyou
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...