>I used the report designer to create a report named invoice.frm.
>In the invoice.frm, the used database is invoice.dbf. Since the invoice.dbf is only stored the customer number, i can't print the customer name. How i add the customer name field in the invoice.frm ? And the customer name is retreived by the customer number.
>
>Waiting for any advice. Thanks!
>
>Dennis

Dennis:

Drag the table with the customer number to the report's data environment. Then drag the key field from customer table to the invoice table's index ( custnum or whatever you called it) to set up a relationship. Put the customer name field on your report and run it.