Hi, Jim, and thanks for the reply.

>How are they shipping, by commercial carrier or some other means? If commercial
>carrier, you should be able to get zone definitions and rates from them that will
>tie into zip codes.

Commercial trucking companies, with various rates depending on the
type of truck used. Currently, the guys in the shipping deparment
are going on-line and looking up the driving distance on google maps
(or some other site..Shrug), and then they're inserting that value
into the local VFP database associated with the app. So, the app
looks to see if the distance already exists, and if it does, then
it displays the value on screen. If not, then the end user has to
go to the web and get the value. This takes a bit of time, and I'm
trying to remove every little bit of time-consuming UI problems.
Proper placement of sorts in a listbox or combobox are wonders
for end users, especially if it saves them time. The way I figure it,
a minute saved here and a minute save there makes an end user happy.


As far as the zones go...is this standard practice in shipping?
Zipcode to zipcode is how most rates are calculated?

Also, UPS provided us with some kind of shipping database app. Now I'm
wondering if I can pull the thing into VFP or MySQL and get the
info I need? I'll have to read their EULA to make sure I'm not
stepping on toes, of course.


Later, and Regards....

Randall