Hey all,
So I'm still pretty new to InfoPath 2010 with trying to query data from different lists.. I've been trying to use the 'eval' formula to get this to work, and have been playing around with it for a couple days now and can't figure out what I'm doing wrong
This is the formula I've been trying to piece together - not even sure if this is the correct one to use -
eval(eval(A, 'concat(B, ";")'), "..")
Here's my situation:
I have a drop down list on my form called 'Related Report' which auto-fills data from a separate SP List called 'CI Reports and Owners' that has 2 columns (Reports and Owners)
What I need to do .. is auto-fill another text box based on the value that is selected on the 'related report' drop down
so if for example 'Expense' is selected .. it goes to the SP List.. looks at that report and then fills in the text box with the owner of that Expense report..
Let me know if that is not enough information, or if you need to see anything on my form but I am totally stuck and this is the last piece of my form I need to get working before it can go into production.
Thanks again for any help provided as again this forum has been a live saver for finding information.
-Andrew