Ratib Hussaini
Registered User.
- Local time
- Today, 14:25
- Joined
- Nov 7, 2012
- Messages
- 31
Hello everyone. I developed a database based on inventory control. It is same as Northwind database, the only difference is that here the inventory is in 3 locations. Now I want add a new feature on my database. Beside controlling inventory, it should show daily income as well. Whatever we sell in a day, from that money we give loan to some employees, do other expenses in company, there are also customers that purchases some products and wont pay the total amount on same day. They pay after some time.
After all expenses and loans it must show how much money left in companies account on daily bases. And whenever employee and customers bring back their due amount, it must be included back to companies account.
Every employee and customers must have loan history, that how much they have taken, how much paid back, how much left and on which date and also reason of loan.
Please guide me, should I make separate tables for these purpose, or should I use queries to collect records from existing tables. Your help will be highly appreciated. Thanks in Advance
After all expenses and loans it must show how much money left in companies account on daily bases. And whenever employee and customers bring back their due amount, it must be included back to companies account.
Every employee and customers must have loan history, that how much they have taken, how much paid back, how much left and on which date and also reason of loan.
Please guide me, should I make separate tables for these purpose, or should I use queries to collect records from existing tables. Your help will be highly appreciated. Thanks in Advance
