InfoPath Dev

what i meant by color coded is that i am using a web editor to create this XML file.  the lines of code are either red or blue but there a a very few lines that seem to be problems as they are basic black.... like i left out some code or have a syntax error someplace. 

Here is the entire code....  there are a few lines that are in black but the rest seems to be color coded.   It is my goal, by creating this XML file, that when one selects a dropdown list choice, that the other fields will auto populate with the data associated with the dropdown choice.  Thank you for your assistance.... this ...

cheason, That actually what I ended up doing. (Creating a field and storing the name in the list). Seems odd to have to have to store the name of the file within the file itself, but it works.

Thanks for your reply. So I was able to get the three columns to change based on what I choose from the first column drop down list, however, if I change the drop down list to something else the other 3 columns don't change ,they don't do anything.  How do I make it update the other columns again?

It works!! you are so Amazing! thanks for helping me out with this...   Carlos

Also, can you elaborate on what you mean by “converted data connections to previous version”?Thanks.

Yes, thank you, however that only works for users in my domain. But what can i do about the external people? I guess I have to with the code solution and build the email myself and so on and attach the form itself as a pdf. I like the idea of having the form rendered in the email body. Michael

 Hi, I don't see any error in this codes are you sure you use C# ? try to zip you form with the codes and attach it. When you reply click on option and then atttach your file.

Hi,  I have a form which on submitting I want to have an admin view to be accessible and updateable by admins defined on a SharePoint list, only. Any other user will go to a confirmation page - is this possible at all?  I've looked at the extended workflow permissions that are possible from codeplex, but these result in an ...

Or keep it simple by setting a 'filename' variable on form open to something like this :-  concat(FirstName, "-", today(), "-", substring(now(), 12, 2), substring(now(), 15, 2))  Will result in something like :- Jason-2010-10-25-1430