I have a table with the following 5 fields:
For each combination of Location - Building - EquipmentClassification – EquipmentType I will have multiple rows.
I would like to create a calculated field that populates the SequentialNumber field. I would like the number to start at 1 and increment by 1. At each change in Location / Building / Class / Type I would like the SequentialNumber to start at 1 again.
I think I can accomplish this by writing script that loops through all of the records in a batch once all my records are entered.
Is there any way this can be accomplished using a calculated field and adding the SequentialNumber as each record is added?