AnsweredAssumed Answered

Cumulative numbering

Question asked by tays01s on Jul 30, 2017
Latest reply on Aug 1, 2017 by philmodjunk

I have 3 tables: A, B, C.

A pk < B_Afk

B pk < C_Bfk &

A Bn < C Bfk where the Bn is set from a Button script.

 

Field from table C are in a Portal on layout from A.

 

Q: If have a C_audit field with a 0/1 checkbox. I'd like to have the record order to appear in another field using the C_audit field with which to calculate the order. It is possible users may delete portal records other than the last one so the 'order' field will have to recalculate.

Outcomes