Qrew LegendTry this as a Formula Query for sequential Line numbering
var text QUERY = "{20.EX.'" & [Related Job] & "'} AND {3.LTE.'" & [Record ID#] & "'}";
Size(
GetFieldValues(
GetRecords($QUERY),3))
Of course...a query formula. Thanks Mark!!
I just noticed that if I add a line item to the PO that may have a Record ID that is not greater than the last item that the added item is not added as the last item # but rather gets inserted in order of the record ID's shifting all other line items down one. Is there any way for these occassions where a line item is added after the fact that the new line item is now = to last item number plus one leaving all othe other line items at the same line item #?
Qrew LegendWell normally, PO Lines lines are added to Purchase Orders by creating a new PO line records and adding them as child to the Parent PO header in sequential fashion.
Do you have a situation where PO lines are created and then later associated with a PO Header?
If that was the case then we would need a process to capture the date and time when that PO Line became associated with the Purchase Order header record and have the formula query look to that field.
