I am using arcmap 10.1 and working in a personal geodatabase. I am trying to add a sequential number to an [encounterID] field to populate a [sightingID] field. What code would i use?
For example I want to sequentially number my encounter ID's and populate the sighting id field as it appear in the sighting ID below and for multiple records.
[encounterID] 20170327.0301 20170327.0301 20170327.0301
[sightingID] 20170327.0301_1 20170327.0301_2 20170327.0301_3