I'm not sure if the subject made sense, but I'll try my best to describe the scenario. I have a sharepoint list that includes the following columns: GeoCode, Zip Code Low Range, Zip Code High Range, Sales Tax, Tax 2.
The infopath 2010 form calculates the total taxes of an amount based on the zip code entered.
So if my row looked like this: GeoCode = "111-111-1111", ZIP Low Range = "30700", Zip High Range = "30720", Tax1 = "0.2", Tax2 = ".05"
The user enters "30715" it would pull back this row with the tax rates and would calculate properly. How would I build this query? Would I need to use code?
Thanks!
Brandon