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
![]() |
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
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.
| All times are GMT -7. The time now is 12:01 PM. |