Before you run the report:

* Use the invoice table in a free workarea
Select 0
Use Invoice
* Use the Customer table in order by customer number
Use Cust in 0 Order CU_NUMBER
* Note the current workarea has Invoice open in it.
* If your invoice table's field refering to customer number is
* IN_CU_NUM, set the relation like this:
Set Relation to IN_CU_NUM INTO Cust
* Run the report:
REPORT FORM invoice && and whatever parameters.

-Adam

>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