Program and Database logic question
Posted on 2012-09-14
I have an issue I am having trouble wrapping my brain around. I have not yet developed the database tables or the program. I am trying to figure out the logic first.
Here is the situation.
I have a list of Pick- up points consisting of 10 different locations:
Pick-Up location A
Pick-Up location B
I have a list of Delivery locations consisting of 12 different locations:
Delivery location A
Delivery location B
pick ups and deliveries can go from any pick up location to any delivery location and will change for each load. Each configuration has a different shipping rate because of the miles traveled. Our dispatchers will select the pick up and delivery location for each load as they are dispatched.
How can I automatically assign the correct rate for any pick up and delivery configuration and apply that rate to the individual load record so that we can bill the customer and pay our drivers the correct amount?
Any help is appreciated.