Re: Looping through a table

Method_Adam — Thu, 06 Dec 2012 15:11:17 GMT

Karen,

Is the service date blank on the screen? Try inputting a service date.

- Adam

Re: Looping through a table

kdellaripa — Thu, 06 Dec 2012 13:24:44 GMT

It's still not working :(

Re: Looping through a table

LaCrews — Thu, 06 Dec 2012 11:40:40 GMT

Karen

its loop through invoiceline table where the field InvoiceRecorcdID = Value from screen RecordID.

Looping through a table

kdellaripa — Thu, 06 Dec 2012 04:30:27 GMT

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

Method:Classic General Q&A

Re: Looping through a table

Re: Looping through a table

Re: Looping through a table

Looping through a table