Re: Forms 4.5: ques. about multi-record blocks

>I have a multi-record block with the current record selected.
>
>During a validation trigger, I want to make a calculation using the value in
>an item in the previous record. I know I can get this value by doing a
>previous_record, referencing the item, followed by a next_record. Is there
>an easier way? I'd like to be able to reference columns in the multi-record
>block as an array, but haven't found any examples of this.
>
>All help is much appreciated,
>Peter
>
No, you can't do a PREVIOUS_RECORD or NEXT_RECORD in a validation trigger. These are both restricted events that cannot be done in a validation trigger.

The only way I have found is real ugly - maintain a record group that contains the same items as the block. Then, the when-validate-item can check that record group for duplicates. This works well, but it is tedious to write.

Dan Received on Fri Dec 05 1997 - 00:00:00 CET