Global list in repeating field

[Jim Carr]

Within a scripted loop that validates a user-found set of records, I'm trying to maintain a list of the records which fail the test, then later generate a report based on the list, kind of like this:

LOOP

If (Field A is empty),

Add its Record# to the end of an Omitted List (a repeating field?)

Add 1 to Omissions Count

Set field Reason Omitted to "Field A was empty"

Omit the record from found set

End IF

Next record

END LOOP

Now we process all records not thus omitted, then here's that list again:

Find each record# in the Omitted List

(by accessing successive repetitions X number of times by loop?)

Sort

Go to Exceptions Report layout

Print Report with record #s and reasons for omission from batch.

My probem is with the list. I am trying to use a repeating field, pasting each successive entry right below the previous one. I am not having much luck with doing that. How do you do this? Or you probably have a better scheme than the repeating field. I hope so. You have bailed me out before.

Any ideas?

[Kurt Knippel]

Stick all of the records PrimaryIDs into one big text field. Then have a relationship from that text field to the PrimaryID field. Once the validation is complete you can simply Goto Related Record via that relationship. Then you will have a nice found set of all the records that failed validation.