I'm doing some testing to make sure I understand how the looping through a table works, and it doesn't seem to be doing what I think it should do. Hoping someone can help me.
I am on the invoice screen, in the invoice line table. I have set up a series of actions in step #5 of the wizard, where after an Edit (clicking the update button), the action to Start looping through a table is called. I am using the InvoiceLine table, where the RecordID is equal to Type In ">0" as the instructions at the top say to do. I have left all other fields blank.
The next step is to Start a Conditional Statement where the Value from Row - Item is Equal to the typed in value "102" (no quotes used in the actual coding)
If the above is true, I want to Enter a Value into a Field on Screen (I have just set up a test label field for this exercise), where the number 999 would be typed into that field.
Then I end the conditional statement, and end the loop.
When I go to the invoice screen, I create a new invoice. I enter the customer, and then go down to the invoice line items. I enter the first item (102), enter QTY, and then click Update. I would expect to see 999 in the test field, but it just stays blank.
What am I missing?
Thanks!
Karen