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?