hello you all! I have a table with [JobNo] = text [StopNo] = number (1,2,3,4…) (one job has multiple stops) [Coordinates] = LatLong [Previous coordinates]=LatLong [Distance]=decimal
How it should work: When a new stop is added for a job, [Previous coordinates] will prefill with [Coordinates] from the previous stop.
This way, I can calculate the distance between stops and ultimately the distance for the route by adding the distances between all stops for that job.
How do I get [Previous coordinates] prefilled?