Database design help

[stonegold87]

Dear members
I need help in design small database what i need is a system to charge students Fee every month ( charging twice issue was resolved with CJ's advise).
What i really want is to add Fee to student account even if number of students are in hundreds process should be really simple and fast
What steps should i take to reach my goal right now i have created
1.tblstudent table
2.tblstudentFeedetails ( studentID as FK)
3.tblstudentFeeMonths where all Fee months will be thr
Plz guide me to proper direction

 

[Ranman256]

make an append query that uses all active students query with fee table, which then appends the fees to the tStudentFees table.
All are then charged at once.

 

[stonegold87]

Good advise Ranman this solves charging student at once
2nd issue how to automatically append query based on date parameter
Suppose if month changes then this action is performed along with month and year detail

 

[stonegold87]

Thx Pat and Ranman i create another table tblFeeDue where i append student Fee information
should i use tblfeedue (PK) in FeeDeposit table as (FK)?