>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
Use an SQL cursor of the two 'Joined' tables as the basis of your report.

SELE *;
FROM INVOICE, CUST;
WHERE CUST.custno = INVOICE.custno;
INTO CURSOR invrept


Wayne