General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only