Loop only creates 1 record

[Barry685]

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)

[bcooney]

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).

[MartieH]

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

[Barry685]

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