I am trying to create a database for our timesheets (please see attached sample).
There are 16 routes, which I have set up in a Route table. I have also set up a table for the drivers and stops.
The top section (bus number, name, date, miles, fuel) are the same area on each one, but the bottom part that has to do with the route (route name/number, stops, times, counts) would be different fore each one.
My first thought is to put the bottom part into a portal. Would this be the logical choice? Or is there a better way to do it?
I can send the FM file if that would help.