Hello Everyone. I have a field, AXE_DB2, which is a sequence number and it allows multiple values. When I delete an item from the list, I would like the sequence number on the rest of the items to be recalculated. For example, if I delete item #3, I would like item #4 to be #3, and #5 to be #4, and so on. Below is part of the code in the Delete button. Is there a way I can do this? Do I use a @For loop? Thanks for your help in advance.
REM {Remove Entry};
REM;
AXE_WKDB2 := @If(ListTotal = 1; “”; Position = 1; @Subset(AXE_DB2; 1 - ListTotal); Position = ListTotal; @Subset(AXE_DB2; ListTotal - 1); @Subset(AXE_DB2; Position - 1) : @Subset(AXE_DB2; Position - ListTotal));
FIELD AXE_DB2 := @Trim(AXE_WKDB2);