HI all, so the challenge:
Lets say I have a table and in that table I have two fields:
- List order (number) - this is the number order in a list
- Item name (text)
1, 'Item A' 2, 'Item B' 3, 'Item C'
So I have a work flow which allows the the deletion of a record, so lets say I delete the first Item A, I now have:
2 , 'Item B' 3 , 'Item C'
BUT: as part of the deletion process I want to update the Order (number) so that I now have:
1, 'Item B' 2, 'Item C'
How, as part of the deletion work-flow, how would I update the remaining record Order field to correctly change the order as above?