Set up an additional table where you create one record for each serial number. Set up a field in this table to produce a serial number. A simple number auto-entered as a serial number would be simplest. You can use a script that takes the Qty specified and generates the needed records in this table and links them by line item ID to the correct line item. A calculation can then pull them as a comma delimited list into the field shown above.
Which script steps would you use for 'You can use a script that takes the Qty specified and generates the needed records'. ?
So I have created the serials table and linked it to the line items table. I have started a script that sets variables for line item ID and Qty but not sure how to tell the script to create the right amount of records as per the Qty.
Thank you for your help !
Set Variable [$Qty ; value: OriginalTable::Qty ]
Go to Layout ["Serials" (Serials)]
Set Variable [$K ;value: $K + 1 ]
Exit Loop If [ $K > $Qty
The above is just the "bare bones". You may need to flesh this out with more code to handle what else besides creating a new record needs to be done.