Dennis,
You JOIN the two tables on the linking field
select invoice.otherfield, customer.name ;
from invoice ;
inner join customer ;
on invoice.customernum = customer.customernum ;
into cursor InvoiceReport
>I am a beginner for writing visual foxpro program.
>
>I create a invoice report, the invoice.dbf just only keep the customer no. But I want to print the customer name in this report. How can i extract the customer name from the customer.dbf by the customer no in the invoice.dbf.
>
>Would anyone can tell me how to do?