>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?
>
>Thanks
>
>Dennis

select name, address1 from customer join invoice on customer.id_number = customer.id_number