Creating a sequential numbering order based on Record ID

Question

Hello,&nbsp;I have an Order Acknowledgments table (parent) and a Line Items table (child).&nbsp;Each Line Item is listed in an embedded report on each OA record. Currently, the RID of the Line Item is shown in the embedded report and I'd like to replace it with a sequential numbering system. So instead of the report displaying random record IDs of the items, I'd like the report to show "1" as the first item in the report, "2" as the second etc. These items are the related line items in the relationship to the OA.&nbsp;

Any help would be greatly appreciated!
------------------------------Todd Molino------------------------------

markshnier__you · Answer

np,This used to be really messy, but now its easy with a Formula Query.Try thisvar text QUERY = "{20.EX.'" &amp; [Related Job] &amp; "'} AND {3.LTE.'" &amp; [Record ID#] &amp; "'}";Size(GetFieldValues(GetRecords($QUERY),3))// replace the 20 with the fid for the field for related parent.// replace related job with the field name for [Related Parent]------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

toddmolino · Answer

Thank you Mark!------------------------------Todd Molino------------------------------

bradelmore · Answer

Thank you Mark -- This worked for me as well.------------------------------Brad Elmore------------------------------

noelherron1 · Answer

Elegant solution, Mark. Thank you very much! Been looking for this for a while.------------------------------Noel Herron------------------------------

Forum Discussion

Creating a sequential numbering order based on Record ID