Create sequential numbering for 2 grouped fileds

Discussion created by pardons on Apr 3, 2012
Latest reply on Apr 3, 2012 by pardons
I am hoping someone will help - I need to create a sequential numbering for polygons dependant on what parish it is in and distance away from parish centre.  I have 2 fields one called Parish which denotes the parish and the other distance showing distance from the parish centre.  Example below.

Parish      Distance     Sequential Number
Parish A   10                                      1
Parish A   20                                      2
Parish A   30                                      3
Parish B   10                                      1
Parish B   20                                      2

I really hope someone can help with some code as I don't want to have to do this manually!!