Hello Anson,
Thanks for the reply. I did watch your second video concerning secondary data sources but it did not quite answer my question.
Here is the best analogy I can present:
I want to enter a value in an InfoPath form and perform an action identical to Excel's VLookup function.
That is, given an index, return 1 to ...