AnsweredAssumed Answered

Refreshing serial numbers

Question asked by SeanLang on Jun 17, 2016
Latest reply on Jun 20, 2016 by richardsrussell

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

 

Thanks

Outcomes