Use a combo box to find an Employee

[Dale G]

Hi,
I’m trying to identify a route driver based on the route number the location
& the time the route was at the location.
I have many routes with the same number (i.e. 100, 200, and 300). All routes
of the same number use the same stops (1st Ave, 5th Ave Jefferson St etc).
All the stop locations are associated with a time the route is scheduled to
stop at that location.
I’m hoping to do is use a series of combo boxes or list boxes or even a
report to find who the driver is by searching the route, location, and time.
The driver is assigned a piece of work (a Run) that has many routes, and the
piece of work is identified by a number i.e. 10, 20, 30, 40, etc (Run Number).
A driver’s piece of work with the number of 10 (Run 10) could have route
100, 200, 300, and 200 again which is a full day of work.
Another driver could have a piece of work (a Run) with the number of 20 and
have the same routes as the driver with number 10.
The difference would be the scheduled time the driver preformed the route.
So far my tables are,

tblEmployees

EmpID, AutoNumber Primary Key
DepID, Number
JobTtlID, Number
EmpNo, Number
EmpStart, Date/Time

tblRoutes

RouteID AutoNumber Primary Key
RouteNumber, Number
RtDir, Text, this is the direction i.e. N or S
IsAlt, Yes/No, in case the route is an alternate

tblRuns

RunID, AutoNumber Primary Key
RumNumber, Text

tblRunRoutes

RunRtID, AutoNumber Primary Key
RunID, Number
RouteID, Number
StartTime, Date/Time

tblZones

ZoneID, AutoNumber Primary Key
ZoneName, Text

tblTimePoints

TimPtID, AutoNumber Primary Key
RunRtID, Number
ZoneID, Number
TimPt, Date/Time

Also I’ve set a combo box up on a form with
SELECT Routes.RouteID, [RouteNum] & " " & [RtDir] & " " &
IIf([IsAlt]=True,"A","") AS [Route Number] FROM Routes;
To receive the route numbers. So far that’s it.
Any help is appreciated.

 

[golfinray]

Martin Greene at www.fontstuff.com or Allen Browne at www.allenbrowne.com
both have excellent examples of how to set up cascading combo boxes, which is
what you need.