Forum Discussion

JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
9 years ago

Formula to number each child record as related to parent record

I want to number each child record for a given parent.  More specifically, I have many Line Items (child) that all below to Proposals (parent).  I want the first Line Item for each Proposal to be numb...
JessicaFeauto2's avatar
JessicaFeauto2
Qrew Cadet
9 years ago
Thanks for everyone's input.  Based on Matt's suggestion, I've added summary fields of # of Line Items and Total Record ID# on the Master Proposals Table and lookup fields of Proposal-# of Line items and Proposal-Total Record ID # on the Details Line Items table.  Still having trouble envisioning which formula could be used to generate the numbering.  Can you give me an idea of the formula?