custom field serialized records from sorted values

Discussion created by cliffribeiro on Jun 2, 2017
Latest reply on Jun 2, 2017 by cliffribeiro

Table 1 - = Table 2 = -Table 3


I would like to take the related records from table 2 and create a serialized field  (1,2,3,4) based on SORTED values in table 3. So if this were

Invoices - InvoiceLineItems - Products


create a serialized invoicelineitems Field that starts with serial #1 based on the sorted order of Products.


Any suggestions approaches?