After a long time I am coming back to my original problem, which is still to solve, i.e., how to print records from the tables below on dot matrix (LQ-300+) Printer.

I would be very thankful if you help in this, because I am searching a lot of sites but could not get the proper answer.

The tables are:

1 PCODE.DBF (Which Contains PARTY CODE AND NAME) ( PCODE C(8), PNAME C(40))

2. SIMAIN.DBF (Which contains Master Records like SINO,DATE,PCODE etc. etc.) ( SINO C(8), PCODE C(8), DATE )

3. SISUB.DBF ( Which contains details records like ITEMCODE,QUANTITY,RATE,AMOUNT) ( ICODE C(8), QUANTITY N(13,2), RATE N(13,2) )

4. ICODE.DBF (Which contains Item details) ( ICODE C(8), FULL_DESC C(40)

For eg.

Party Code: CA001 Name: ABC International

Sales Invoice No. SI1000100

Date: 12/04/2006

--------------------------------------------------------------------------
Item Description Quantity Rate Amount
Code
--------------------------------------------------------------------------
A001 MUSICAL ALBUM 100 DOZ 5.00 500.00
B001 BALOONS KOREAN 50 PKTS 2.00 100.00

--------------------------------------------------------------------------
TOTAL 600.00
==========================================================================

I went through the examples which I got from public forums, but it did not serve my purpose.

Thanks/Regards - Saifuddin


Saify