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.

Any help would be greatly appreiated.

Craig

TimeSheetSample.pdf

A portal makes the most sense for a workflow where you need to fill in a form and a number of related details, i. e. line items.

But about your outlined data model: isn't a route actually a template for a shift, which is a specific driver driving a predestined route on a specific date?