Iterating through a repeating table.

[randyb]

I have been trying for some time to iterate through a repeating table.
Either it will only work on the first item in the table or it will work on
each item in the table but I have to touch each record for the even to
trigger. How do I update field A based on the value in field B. I am using
InfoPath 2003.

Thanks,

Randy

 

[Ben Walters]

Hey Randy,
As I understand it you want to update the value in one field and have that
flow through each record in a repeating table is that correct?

 

[randyb]

I have date a and date b in a repeating table. I want to calculate the
number of days between them. I have sample code that works but not how I
need it too. One set of code I tried only worked on the first record in the
table. I ran it from the form load event and a field change event. THe 2nd
set of code I tried used a change event for one of the fields. <y plan was
for it to execute as the form loaded. It did not work. If I changed a value
and then left it would work but that is not feasible. I have several hundred
fields. I am simple trying to find the right code that will work as soon as
the form loads. I wan it to calculate all the fields at once.

Thanks,
Randy

 

[Shekar]

Hi randyb
Any way data for table is set in OnLoad event, after data is set in the
repeating table, write a loop statement and call the method which calculates
the number of days between two dates.

Hope this helps you.