If your problem is that you aren't picking up the corrent last_rec value, you may need to
select cdcid
m.last_rec = last_rec
select newtable
for i = 1 to m.last_rec
append blank
next
>To modify your code just slightly
>
>FOR i = 1 to RECCOUNT('cdcid')
>APPEND BLANK
>NEXT
>
>HTH
>
>
>>I'm trying to create a FOR statement that will appen blank records in a table >based on the number of records in a different table.
>
>>FOR i=1 TO CDCID.LAST_REC
>>APPEND BLANK
>>ENDFOR
>
>>CDCID.LAST_REC contains the total number of records that's been entered in for >the current session.
--Todd Sherman
-Wake Up! Smell the Coffee!