I'd add a field called "Branch" to the invoices and inventory tables, etc. which is a foreign key to the Branches table, which would hold the name of the Branch, and maybe the address, the manager's name, etc. This Branch information would go at the top of reports, maybe on forms, etc.


>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