I have a multiple text field with the following options:
Tool Room-8I have another field called document Number that I need to build a sequential number starting at zero for each of these categories based on how many of each record there are. For example; if I enter a record and select HR-7 and it is the first record with HR-7 selected, I need my Doc Number field to auto populate 001. If it is the third QA-1 record created, i need it to auto populate 003. Each option needs it's own sequencing.