i need my query to find a mileage associated with a starting location and destination.
however i dont know how to make my sql get the selected items from the form and use that to know which table to retrieve the mileage.

i need it to open the table that matches the location in the start field, and find the destination in that table's "column A" and return the mile associated with it found in "column B" back to a field in the form called miles.


Any suggestions?