InfoPath Dev

Hi,

I have a repeating table with 3 variables:

"CurrentRecord": automatically filled with a sequential record number 1,2,3...

"Track": boolean: filled by the user as yes/no

"NextTrackedStep": number which should be calculated as the "CurrentRecord" of the next record where "Tracked" is true.

The table looks like this:

Current Record; Track; Next Tracked Step

1;true;2

2;true;5

3;false;5

4;false;5

5;true;6

6;true;

 I tried this formula for the default value of "NextTrackedStep" but it does not work:   ../following-sibling::my:group2[true() = (../following-sibling::my:group2/my:Track)]/my:CurrentRecord

Event though this is a simple search problem I could not find an article that really fits. 

Any idea?

I attach the XSN and XML files.

 Regards

Andreas 

I think this would be the right formula:

../following-sibling::my:group2[my:Track = "true"]/my:CurrentRecord

Hi Hilary, thanks - great - it works perfectly.