Hello: I have a table of CLIENTS and a table...

Hello:

I have a table of CLIENTS and a table of CONTRACTORS, each one of them have Coordinates of their location. I have a formula that calculates the DISTANCE between each one.

How can i show in the dropdown list of CONTRACTORS in a form the ones that are closer to the CLIENT based on the distance?

0 33 716
33 REPLIES 33
Top Labels in this Space