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.