InfoPath Dev

Hi It's possible to change one cell value in secondary data source (SQL database table). I need to replace one value from this table, insert into proper column user name, who recently modified main data source. I can used to tables as main data source, but in the second I don't need to add rows. Only replace user name in one row.

This is no only 'cat' to 'CAT'. Text field must be upper case. Such 'xxxx' to 'XXXX' when xxxx for example first name of user. And when is 'John' in the second field text must be 'JOHN'. Dynamic conversion.

Hi I need to change text to uppercase. Is any function in InfoPath do to this? For example change 'cat' into 'CAT'.

Hi I have problem with two forms. I need to send field value (text), from one form, not submitted, to second. Example, select country and push button 'Open member form' I need in the second form country text already filled value from first form, then I only must enter name. I use MS SQL 2000 bases. I try to use xms file but this not ...

Hello I change something in SQL table, when I filled my InfoPath form, and click Send button to sent my data to SQL database, I see error ''Multiple colons are not allowed in a name''. I have no idea what's a problem! Paul

Thanks for this solution!

Thanks for reply I don't want to have the same value in the textbox and dropdown field. I have person for example John Smith in my secondary source. When I choose John in dropdown, in the textfield must show Smith. Next row next person. In first row works good but next not good. It's depends what was choosen in the first row. I read about ...

My problem. I have repeating table with one drop-down formant and text field. When choose for example from drop-down formant name, in the text field apears forname of the same person. All the field are linked to the secondary source (SQL base). and now I paste next row in my table. And again, choose name and suprise...., in text field appers wrong ...