asked on

Program and Database logic question

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
etc.

I have a list of Delivery locations consisting of 12 different locations:
Delivery location A
Delivery location B
etc.

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.

thanks.

ASKER CERTIFIED SOLUTION

Alan Warren

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rtay

ASKER

Thanks Alan that info was great.

quick follow up question, I could close this question and create a new one if you prefer. just let me know.

Anyway,

in a asp.net page I have a gridview from a table tbl_loadRecord.

I pull the ship_location and delivery location from dropdowns from the various tables. how do I call that procedure, pass the loadRecord key and the other two parameters and insert the stored procedure rate value into the rate field in loadRecord table?

Thanks.

rtay

ASKER

Thank you. This solution was great.