Map location in 1 table(lat/long) to the nearest Depot (lat/long) in other table

Hi,

I have a table (UNSTICK) with depots and they all have a column (Geo) with lat/long.
I have a second table (DEPOT) where I get the current position (lat/long) and in that second table I want to show the nearest depot and the distance to that depot.
Here is how I want it ( see first record in UNSTICK)
Table UNSTICK


Table DEPOT
contains the columns:
DepotName - GEO

Is this possible?

Thanks for any help.
Hoover

0 1 107
1 REPLY 1

Top Labels in this Space