Auditing Repeating Fields

[RickK]

I've gleaned some good info in the "Samples" forum for creating an audit trail for records. I have run into one problem that I could use some advise on.

The auditing info works great on non-repeating fields, but with repeating fields [status(CurrentFieldContents)] it picks up only the first cell. Changes made in cell 2,3,4, etc are not detected and translated.

My db contains both standard text fields and many repeating fields (it's a purchase order system). Any ideas?

[Ricardo]

Try using the GET REPETITION function from the Repetition functions.

e.g

GetRepetition( Field; 2) - this will get the info of what is in repition 2 of the field.

Hope this helps,

ricardo

[RickK]

Thanks, I was able to solve this myself by creating a calculating field, then used GetRepetition(d.ItemDescription1.t.r,1 <> 31), there are 31 repeating cells. This works, not real clean but did the job.

It's rough alright, it hockey!