2 Replies Latest reply on Jun 18, 2015 7:46 AM by BraydenDykman

    Autofill 1 field based on the value of 2 other fields

    BraydenDykman

      Title

      Autofill 1 field based on the value of 2 other fields

      Post

      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?

       

      Thanks