Wow. I have been literally pulling my hair out (luckily I have a lot to spare) over this one.

Learn how you can use data validation in InfoPath to make a field required based on a condition or the value of another field. Making a control required in InfoPath means applying data validation to that control. There are 3 ways to apply InfoPath data validation: Use data types Use data validation rules Use rules

Ok, so I have been “evangelizing” the glories of InfoPath until my throat is sore.  I see what is on the horizon and since it happens to be an area of particular passion for me, I am happy to share with anyone.  I finally found an article that says what I have been trying to

It is common to need two or more list boxes where the choices in one are dependant on the value of another. This is known as a cascading list. A cascade can occur with as few as two levels up to any number of levels.

 I am constantly collecting links to great online information related to InfoPath / SharePoint Integration.  I am including some of them below and I will be adding more as I go along. Enjoy!

translate Returns the first text string with each character in the second text string replaced by the character at the corresponding position in the third text string.

I found the best article about how to get the current user in InfoPath WITHOUT WRITING CODE!  Amazing, especially considering I work at a “no custom code allowed” company..  Much thanks to Itay Shakury. 

Microsoft Office InfoPath 2003 SP1 introduces a number of new controls. One of these new controls, the file attachment control, enables you to insert files which will be encoded and saved with the form. This control opens up a number of new scenarios not easily possible before SP1.

I finally took the time to research / learn how to grant certain permissions based off of a Users ID.  Since I do a ton of work with InfoPath / SharePoint Integration, this was a fairly critical item.  Also, since ExxonMobil does not allow “code solutions”, I had to find a way to achieve this

Ok, so this one I have been looking for for a while! I want to be able to retrieve Active Directory information for the user of my snazzy Infopath forms.