I use a form that auto-increments our Site ID by 1 each time a new record is made. However, I would like the option to have a field be auto-incremented based on the status field. E.g. If the first two sites have status A and site 3 has status B, site 3 will start back at 1 as it is the first site with status B even though it's the third record.