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?
Steve Gibson