Autofill 1 field based on the value of 2 other fields
First off, I am very new to FM. I am trying to create a simple database to track vehicle mileage. I want to be able to enter a start location, an end location and the distance travelled The part I'm having issues with is having the distance field autofill based on the start and end location. Example: If I have entered that traveling from A to B is 100 units of distance in the past, I want the distance value to autofill if another entry from A to B is submitted in the future. How would I go about this?