Lookup Table

[MartyLake]

I am making a mileage form in InfoPath and want to implement a lookup table
of some sort. There will be a drop-down box for "From" location and a
drop-down box for "To" location. I want InfoPath to calculate the distance
between these 2 locations based on a table of entries I give it. I'm not
really sure how to do this. Any suggestions are appreciated. Thanks!

 

[Hilary Stoupa]

Hi:

So your lookup table will have three columns, From, To and Distance? Or will
there be another table that you use for a calculation based on the selections
in your other drop downs?

If it is the first scenario, you can connect an expression box (for example)
to the Distance field from your secondary data connection and filter it based
on the selections in the To and From drop downs. If it is the second
scenario, more information about your intended set up would be helpful.

 

[MartyLake]

Thanks for the reply. I used this article as a guide and made the distance a
text box with a filter based on the To and From values. For the data source,
I used a SharePoint list.

http://msmvps.com/blogs/benwalters/archive/2007/08/05/filtered-drop-down-lists-101.aspx