Creating a Databus to manage school bus ridership...
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:
AM Route (A Map)
PM Route (A Map)
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!