I have a customer table with clients, addresses, visitation days and visitation order. The visitation days and visitation order work like this: Juan’s Nacho Shop, Monday, 3 means Juan is visited on Monday and is the 3rd stop.
We maintain a route book with Mapquest printouts from one stop to the next. As we add/delete clients, we have to re-run all the maps. In Access, how can I build a mechanism that pulls driving directions from one stop to the next for each day and adjusts to the customer table automatically?
Thanks,
Dashiell