Need Script to Loop thru a table and check each field
Can anyone help me script the following:
Loop thru a table with all fields in table on one layout and store result in a different table
Starting with the first field of the first record in the main looping table:
(1) Check the field(numeric) for a value greater than 0
If the field value is greater than 0
Create a new record in a different table
copy the field value that was greater than zero into the new record in the different table
copy the fields name also into the new record in the different table
Now get the next field (looping table) after this one and copy it's value also into the new record.
Check to see if t there are no more fields in the first record of the looping table.
If there are more fields then loop back to (1)
If there ar NO more fields then get then next record, unless were out of records in the looping table
If there are more records then get the next record and start looping the all the fields.