Happy New Year for everybody
I'm developing a personal finance database.
My idea is go beyond of only insert income and expenses/outcomes.
I want to develop an annual budget so I can monitor monthly what is jeopardizing my money.
Instead of for each month I prepare budget for each category, my idea is after fill a general one, a loop go through the values and based in what I had inserted there, generate for each month (Jan to Dec) so I can have an annul budget.
Will be like:
I don't know how to generate this loop.
I'm developing a personal finance database.
My idea is go beyond of only insert income and expenses/outcomes.
I want to develop an annual budget so I can monitor monthly what is jeopardizing my money.
- tblBudget
- idBudget (primary Key)
- BudgetYear (year of budget)
- fkCategory (Category such as Food, Health, Transport, Household, etc.)
- tblBudgetDetails
- idBgtDetails (primary Key)
- fkBudget (Foreign Key associated to tblBudget)
- fkSubCategory (Such as Restaurant, Medicine, Car, etc.)
- referenceDate
- ExpenseValue
Instead of for each month I prepare budget for each category, my idea is after fill a general one, a loop go through the values and based in what I had inserted there, generate for each month (Jan to Dec) so I can have an annul budget.
Will be like:
- Update a temporary table (tblTmpBudget) with my records inserted on Budget Details table (tblBudgetDetails)
- Delete the records on Budget Details table (tblBudgetDetails)
- Read by recordset all values of tmpBudget
- Insert back on tblBudgetDetails each record splitting it by month inserting dates on referenceDate as per record of tblTmpBudget
I don't know how to generate this loop.