CrossReference list in InfoPath

MikeRow — Mon, 05 Nov 2012 22:01:00 GMT

Newbie to InfoPath.

Trying to convert a Cross Refrence list in a word table to an interactive InfoPath form.

Row and column names area the same list of items.

Pick the Item Row, then pick the column. Return value from Row/Column intesection.

Order of selection matters. Row 3/Column 4 could have different value than Row 4/Column3.

Simlar to a "Distance Between Cities" chart on a printed road map.

User would select "City A" from the drop down list.

Then select "City B"

Result would provide a number used to determine next action.

A to B might be a different path than B to A so distance could be different.

Can't figure out a way to tell infopath, If Item1 = 4 and Item 2 = 17 find field 17 in record for Item4 (Row 4/17Column)

as above if Item 1 = 17 and Item 2 = 4 then find field 4 in row 17 result may be different value.

Values are predetermined in the list.

Just need a method to retreive the specified value properly.

Any help would be appreciated.

General