InfoPath Dev

 Hi - I have a drop-down field that gets the choices from an external data source and I am filtering the list based on the value of another field from the same list. The list contains values for Vendors and Contracts. A single vendor can have multiple Contracts but I want to display the active Contracts based on certain criteria and it's ...

 Hi - I have a from with 2 drop-downs that is filtered based on the selection of the first drop-down and data in my SP list. I want to further filter the data based on a Boolean field in the SP list. I can't figure out the logic to filter it based on a second criteria. The first drop-down (Field Code) sets the values of the second ...

Hilary - You are the bomb! Thank you so much! It works perfectly now.

 Thanks! Seems so obvious now that you point out the slanted quotes.   No luck but now have a different error.   msxml6.dll Reference to undeclared namespace prefix: 'pc'. Error occurred during a call to property or method 'Eval'.

Thanks for the quick response Hilary!    I tried and I'm still getting this error...   Unexpected character. xdMath:Eval(xdMath:Eval(my:group1/my:group2/my:group/pc:Person, -->‘<--concat(pc:DisplayName, “;”)’), “..”)

 Hi - I am hopelessly trying to follow the other posts for concatenating multiple text strings from a repeating section but keep getting errors. I am using the Person/Group Picker as my control in the repeating section and I want to concatenate the DisplayName so I can get a list of people to email. I used the following formula with no luck. ...

 Now I get it! Thanks! It worked by setting the default to the translate formula. I had it as a rule and didn't realize you could put formulas like that as defaults...learned something new.   Thanks Hilary!

 Thanks for the quick reply. What do you suggest using as a default value? Not quite sure I understand.

 Hi - In my form I am using the Person/Group Picker control to set an approver and in order for the approver to be able to approve the form I need to verify the AccountID from the people picker matches the CurrentUser. On Form Load a Rule translate the CurrentUser ID to all lowercase and I need to do the same on the AccountID field from the ...