I have a table called 'place' which has pre-calculated driving distances from my office to various cities and zip codes in California. In my table 'job' I have set the add/edit field for 'job_city' to lookup values from 'place_city' and save the value ( city name itself ). If I run the follow query on my database 68.24, 73, 1. I want my application to run this query before adding or updating a record where the 'place_city' value in the query matches the value I set for 'job_city' (Oakland in my example) and then update fields 'job_dist', 'job_min', 'job_bid' with the results of the query. I would be grateful for any direction or examples on how to accomplish this.