moradisndat
Registered User.
- Local time
- Yesterday, 19:31
- Joined
- Mar 27, 2015
- Messages
- 14
Hi, I hope I am posting this in the right place. I have an inventory database with tables for Inventory Transactions, Purchases, Sales, etc. Everything is fine with that. But my boss wants to be able to pull reports at random to see cash flow. I created some tables that are not related to inventory: Payroll, Expenses, Income (for misc income that is not related to inventory such as commission) Then I realized I can't get the information I need because the tables are not related.
I thought maybe the unrelated tables need to be in a different database. But even if I do that, I'm still not sure how to get the information that I need. I looked at linking the tables, appending records from the inventory db to a table in an external db. Now I'm just totally confused.
This is the information I need for prior months or month-to-date: totals for Purchases, Sales, Payroll, Expenses, Misc Income.
Any help with how that should be done would be greatly appreciated. I'm so frustrated I'd like to just give up but I've already put so much time in that would be such a waste to give up now.
I thought maybe the unrelated tables need to be in a different database. But even if I do that, I'm still not sure how to get the information that I need. I looked at linking the tables, appending records from the inventory db to a table in an external db. Now I'm just totally confused.
This is the information I need for prior months or month-to-date: totals for Purchases, Sales, Payroll, Expenses, Misc Income.
Any help with how that should be done would be greatly appreciated. I'm so frustrated I'd like to just give up but I've already put so much time in that would be such a waste to give up now.