7 Replies Latest reply on May 31, 2012 1:45 PM by GaryMyers

    Creating a Databus to manage school bus ridership...

    GaryMyers

      Title

      Creating a Databus to manage school bus ridership...

      Post

      I have read a couple posts related to setting up a database to track class attendance. I am using some of these suggestions to set up a database to track student bus ridership.  Ideally, the students would select their name as they get on and off the bus, under the supervision of the driver, using a mobile device of some kind. My question relates to establishing the relationship between the tables...I am quite a novice in this area. I want to track that the students were or were not on the bus in the AM and the PM...so I have these tables:

      Student
      Name
      IDNumber
      School
      Contact Info

      Bus
      Bus Number
      AM Route (A Map)
      PM Route (A Map)

      AMRidership
      Date
      Bus Number
      StudentID
      RideStatus

      PMRidership
      Date
      Bus Number
      StudentID
      RideStatus

      Now I need to know now to connect them, which is the challenge for me. I'd like to have a layout that allows the student to mark their attendance as they get on the bus. I'd appreciate any suggestions you might have!