Recent content by stonegold87

Waiting for your response @Pat Hartman

Thx @Pat Hartman plz explain the idea of another junction table you suggested before for annual and monthly Fees in Post #16 in detail What would be the next step which tables to join with junction table ? TblFeeAccount with tbl Invoice? And which (Fk's) to include ? Kindly explain this last...

Thx Pat helpful as always School has many Classes with different Fees structures what is the best approach to handle this situation Suppose a student admitted in kindergarten Has different Registeration Fee Tution Fee When he gets promoted to next class fee structure vl change

Ok understood everything up till now next question is what if every class has seperate Fee structure should i include class id in tblFeeAccount ? Also how to make relation with tblInvoice?

Thanks Pat this is really helpful

Thank you so much Pat now things are much clearer would u be kind enough to share any example or guide me on this test file to how to create query and Form to handle many to many relations

Pat i m having confusion regarding multiple Fees i understood row and column Description i just want to clarify if i charge Registeration Fee and Tuition Fee both have their own Row so how do i join these two rows with tblStudentFees with single (FK)

Thx again Pat for such detailed response plz look at this test File i m trying to clear my concept Plz explain Fee ID (FK) in tblStudentFees 1.what if thr are multiple Fees applicable? 2.should i create a child table for Additional Fees? 3.or should i create extra tables for Tuition Fee and...

Thx Pat ur reply is really encouraging ok i try to explain 1. Payments will be made full for particular Fee month no partial payments etc 2. Types of Fee a.Registeration Fee ( one time) / year b.boarding Fee ( one time ) / year c.transportation Fee (one time) / year...

Thx Jdraw i look at that diagram and thr is one confusion Why does tblstudentFeeDue and tblstudentFeecollected both tables have Student fee due date and Student fee collected date fields ?

Thx g37sam yes there are three more Fee types and i want users to modify

Thx for ur reply Ranman could u plz eleborate issue date and paid date a bit more and also about append routine

Dear Members I have a question regarding table design i m trying to develop a simple Student Fee Management System I have student table Student ID Name etc Fee Detail table Fee detail ID student ID (FK) Fee ID (FK) Discount Fee Account table Fee ID Tuition Fee (monthly)...

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)?

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