Ravi,

The APPEND from command opens the table, but does not assign it an alias. Try:

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

>Thanks Nadya. I got the following message "Alias REFDOCSADDY is not found". This is a table in the same directory that all other tables are located in. What should I consider? Thanks again.