AnsweredAssumed Answered

Creating a Databus to manage school bus ridership...

Question asked by GaryMyers on May 17, 2012
Latest reply on May 31, 2012 by 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!

Outcomes