Hello everyone.
I need to duplicate the sales orders (from SalesParmTable) for which the user is generating a proforma for a certain project, and then I need to re-insert those sales orders in SalesParmtable once the proforma has been created.
below is my code.
The issue is that, despite their being several records with the parmId, I always get just one record from SalesParmTable.
Any kind of help would be very much appreciated.
When I debug, I can see that I have the correct parmId, but SalesParmTable does not loop through; instead, it appears as though there is just one record, even though there are multiple records with that parmId when I check SalesParmTable.