Vehicle Dispatch program

[Scott]

I want to write a relatively simple vehicle dispatch program that includes a
report that tells me what vehicles and what drivers are available for
dispatch on a given day. I've seen some programs that go over the top for my
needs. I started the program and I have some reports that give me a good
picture of the status of trips, but I am now stuck with the problem of doing
(what I had thought/hoped would be) a relatively simple report that tells me
what vehicles are available for dispatch on a given day. When I say simple I
mean we have 4 vehicles and 4 drivers and the report needs to be only for a
given week (Sunday through Saturday).

I don't want to reinvent a wheel, but I also don't want to get a mammoth
vehicle dispatch project. If someone can point me to examples that I may be
able to get some good ideas from, I would love to see what's out there.

I would be happy to share what I have done so far and where I am running
into problems if you think you could help me get the last piece of this
together.

Thanks for any help you can give.

 

[David H]

How is your data structured?

How are you indicating that a vehicle is assigned to a run?

Are you dealing with 1 run per vehicle per day or multiple runs per vehicle
in a given day?

I spent far too many years in transportation so I'm quite familar with the
issues.