What do you mean by "for the first record only"? Are you expecting it to append several records? A not eof() loop won't help...because that function won't evaluate properly for the table you are appending from (at least I don't think it will).


>>

APPEND FROM refdocsaddy FIELDS speciality, ;
>>       location FOR number = m.lnNumber

>>
>Hi Steve:
>
>Thank you for your response. This works, for the first record only though. Should I put in a do while not (eof) loop?