Simple Budget in Access

[alamnizamani]

This register shows budget allocation in each code, continued sum of budget utilized, continued budget utilized and balance of each code.
i have idea to prepare budget register in access 2007. my table is as under

tblAccount

AccountID-autonumber
AccountNo-Number,drop-down list
AccountName

tblTransaction

TransactionID, autonumber
TransactionDate, date
AccountNo-number, related to tblAccount
Description-text
bill amount-currency
budget amount-current

tblBudget

budgetID
AccountID, related accountID
Budget_allocated, currency

 

[MarkK]

You did not ask a question or describe a problem.

 

[alamnizamani]

sir my table does not show proper relation
please show me table relation

 

[MarkK]

Are you asking how to create a relationship between tables?

 

[alamnizamani]

Yes, I have been trying to prepare a budget ledger for my small business where i can allocate yearly budget and additional budget. And expense occurred during the year must be controlled.