Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Tuition on Students and Clases (https://www.askmehelpdesk.com/showthread.php?t=383370)

  • Aug 4, 2009, 11:24 AM
    jacintowesly
    Tuition on Students and Clases
    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
  • Aug 4, 2009, 11:36 AM
    ScottGem

    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.