Dearest VB GuRus,
thanks for all your contributions. this time, I have a problem and I need your magnanimous assistance and contributions.
I have developed a a VB Cash-expense application and I am designing a Database using MS-Access to be used as back-end.
I am confused on which fields should BE in the following tables below.
Table1: Department (This table has all the departments that are eligible to receive cash and make purchases.)
Table2: Items (this table has all items that are purchasable by all the departments.)
Table3: Purchases (This table SHOULD record all purchases made by individual departments.)
Table4: ReceiveableCash (This table SHOULD record all receivable cash that comes into the organisation (NOT THE DEPARTMENT).
Table5: PayableCash (This table SHOULD record all financial expenses made to a particular department.)
Table6: Accounts (This table records all the currentBalance, accountName and the AccountCode of different accounts. Every financial transaction is through a particular account.)
Kindly help me on the design of the above tables.
I do not know which fields should be included in the respective tables.
But my conception is:
I do not know what SHOULD constitutes these table above and I really need your kindest assistance in the design.
Moreover, I also need to know the how to construct an SQL SELECT statement that will retrieve all expenses made.