LE9 build 6755 - "multiview error: derivation in field is recurrent'
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