I have a db with over 20k records and I'm introducing a new field to my child table. Each Parent cant have many childs and for each child I would like to assign a unique number starting with 1.
the goal is to see all my child items the following way.
Parent, child ID, ActivePortalRowNumber
6294 14785236 1
6294 14785237 2
6295 14785238 1
6296 14785239 1
6296 14785240 2
6296 14785241 3
My current challenge is that I can create a calc to get the active portal row number, but its only going forward. how can I go back and set the rest of the 20k.