I'm trying to see what is the best way to configure lookups in Laserfiche Forms for mileage calculation. Employees get reimbursed for traveling from branch to branch, so we created a database with the distance between each branch. We want to have a lookup so that when users enter the starting location and then enter the destination, the mileage will be prefilled. Is there a way to do this in Laserfiche Forms with the below database? Do I need to reconfigure the database to make this lookup work as intended?
Here's a sample of what the database looks like: