Enforce unique numbering - avoid duplicates on child tables of task
useful reading here:
for my solution I went for the recommended business rule solution, and defined the business rule to run on "task" table and inherited by child tables (incident etc)
still trying to get to the bottom of how exactly the issue of duplicate incident numbers being generated on the incident form arises, but in the meantime no more duplicate tickets in our instance!
examples of how the transaction logs might be checked for the issue: