Simplicty and flexibility!


LE9 build 6755 - "multiview error: derivation in field is recurrent'


Started by Sam Bird
Search
You will need to Sign In to be able to add or comment on the forum!

LE9 build 6755 - "multiview error: derivation in field is recurrent'

After latest LE9 6755 update the following error message appears when opening a form that has always worked before without this error.

"multiview error: derivation formula for the field 'Repeat2' is recurrent is recurrent'

It also gives the same error if records are entered or updated in the table is via DQL.

Repeat2 is a virtual field which checks how many repeats there are for the "AR_Barcode" value in the same table.

      if(AR_Barcode not = blank and Repeat2 = blank , count of "rSub_Submissions" + 1, 0 )

AR_Barcode is not the unique key for the table.

'rSub_Submissions'  relationship is for the AR_Barcode field in the Submissions table vs the AR_Barcode field in the Submissions table


Written by Sam Bird 09/09/24 at 20:34:23
DG3_ForumList