AnsweredAssumed Answered

Running Number Field

Question asked by macastronomer on Mar 23, 2017
Latest reply on Mar 23, 2017 by macastronomer

I am trying to make a calculation field auto-enter a running number. This is a daughter table related to a parent table. The daughter field can have 1 or more related records. I need the running number of that related record (not total records).

 

In other words...

___________________________________________________

     Parent Table, key-field, record 1 : 12345

 

     Parent table, key-field, record 2 : 12346

___________________________________________________

     daughter table, record #1, related-field : 12345

     running number field: 001

 

     daughter table, record #2, related-field : 12345

     running number field: 002

 

     daughter table, record #3, related-field : 12345

     running number field: 003

 

     daughter table, record #4, related-field : 12346

     running number field: 001

 

     daughter table, record #5, related-field : 12346

     running number field: 002

___________________________________________________

 

I hope this makes sense.

 

Thanks for the help.

Outcomes