Im trying to create records in another table that is based on looping thru the Invoice line items of a specific Invoice. It is activated from a button on an invoice.

Before the loop begins I assign the invoice id to a local variable.
Perform a find on the line items table limiting the line items to just that Invoice.
I than sort the line items by a specific field.


The problem that I am having is the looping sequence only creates 1 record in the other table (from the first record in the line items found set)

I'd like to help, but I'd rather understand the use case. What are you trying to do and why? (then we can get to how to script it).

I am thinking that it's the opening of the new window that is causing the issue - I think that is messing with your loop as the script is trying to continue in the new window. You can see this for sure if you run a debug on it. I think I would forgo the new window and just go back and forth between the two layouts until the loop is complete - then, go to the document layout.

 

hth,
Martie

sorry for taking so long to reply. Martie had the answer I needed to close the window.