Hi all
Hope someone can assist with a problem
I'm doing an infopath form where the user inserts a document number.
The number is semi-intelligent so if I use the substring function using XPath in a text box called "docSubType" I can extract the 8th digit of the doc number to equal a document type (eg A).
I would now like to add to either that field or an additional one that if the doc type in the field mentioned above = "A" insert the text "Report", if the doc type = C insert the word "Calculation" etc etc. If Access eg we would use if([docsubtype]="A","Report",if([docsubtype]="C","Calculation","")) etc
Any ideas on how to do that in InfoPath? I am not into writing code so any assistance would be appreciated
Thanks..... Rob