DB desighn

[Hamoud Alrashid]

I created a Budget program. Our needs are very simple.
Our budget Contains about 10 acounts (account
361,363...etc). Every account amount divides into 12
months. So you can't spend more than the month amount.
For example if Jan amount in budget is $1600.00 , and
Expense $1200.00. So the remaining is $400.00 will go to
Feb to be the amount of Feb is $2000.00 ($1600.00 Feb
budget + $400.00 remaining). In Feb you can spend
$2000.00 as expenses, but not more than it.

In this DB, I created 3 Tables. 1st for Description of
accounts. 2nd for the budget that distribute it to the
months , and every account has 12 records in the year.
The last table is for expenses, but every account may has
more than 1 record in the month.

My problem is, When I make query and join the tables with
each other, the result is wrong because the records of
2nd table will be as much as the record of 3d table.
This problem also appears in Reports also , so the total
of budget will be wrong because the records in 2nd tables
be duplicated.


Please help me and many
thanks