7 Replies Latest reply on Jun 20, 2016 7:31 AM by richardsrussell

    Refreshing serial numbers


      I am trying to set up separate sets of serial numbers for a group of records within a project. For example, I have a parent table called project, and within that is a child table for tools. I want to restart the serial number attached to each tool set so it starts at #1 with each project. How do I do this?


      Project A

           Tool A-1

           Tool A-2

           Tool A-3

      Project B

           Tool B-1

           Tool B-2

           Tool B-3