-
Create a ID field, and add a default value to it as below:
count(preceding-sibling::<SectionName>)+1
-
Why don't you set a 1 character limit to a textbox? In the text box properties, go to the 'Display' tab and set the limit.
Attached a snapshot from InfoPath 2010....
-
Have you tried using the same query in SQL? Does it return the correct number of rows?
I just tried using join, and it returns all the specified rows of data in InfoPath.
-
-
-
-
-
-
-