>thanks Hilmar your reply.
>in youe second answer
>need only one line or this line is need for each record
>scatter name loRecord
>
> scatter code loRecord
>scatter level loRecord
>.........
For each record, in both cases.
SCAN is a special loop that will go through all the records in the cursor.
SCATTER NAME will create an object called loRecord (in this example). Each field will be a property of the object loRecord, so that you can access loRecord.Field1, loRecord.Field2, etc.
If the field names are the same in both tables, you can also use GATHER NAME with the object loRecord, created previously with SCATTER NAME.
In many cases, you can also get the field values directly from the cursor or table name - MyCursor.Field1 - without using intermediate variables or objects.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)