PDA

View Full Version : Tuition on Students and Clases


jacintowesly
Aug 4, 2009, 11:24 AM
I have been trying to include tuition (monthly payments) on the Students and Classes database that comes with Ms Access. What tables should I add and How should I relate them.

Jack

ScottGem
Aug 4, 2009, 11:36 AM
Assuming you are just tracking payments you would add a table like so:

TblTuitionPmt
TuitionPmtID (PK Autonumber)
StudentID
ClassID
PmtAmt
PmtDate

I would then create a subform bound top this table. You can embed that subfom top your students form to show a record of payments for the currenmtly displayed student. You can also do the same for the class table.