Dear friends,

I have simple Invoice printing program.

Data entry of program Generates invoice No,
Accepts Invoice Date , Party code into Master file(Invice.dbf).

It acceepts Item from item master , Qty , Rate and Amount into
Child file(Inv_det.dbf).

Detail description from Item master is stored in Masterfile's
memo fields for the first time. Then user is allowed to enter
his description.

I have 4 parallel memo fields for invoice detail so that
User can type his own description over description from
Item master. (structure given below.)

Problem : When users inserts his own description in memo field using
Invoice entry module , I want parallel memo fields also to be inserted with Blank line if new line is inserted in description . So that Quantity , Rate and Amount field remains in same line where the Item description starts.

e.g. 9893/ 2003 Precision weigh 10 150 $ 1500
machine. LicNo. 03824
Weight 3.25 Kgs.
(User can type multiple line
desc here.. BUT all the memos
should be shifted below from here.)

2393/2003 Precision weigh 5 150 $ 750
machine. LicNo. 03824
Weight 3.25 Kgs.


Note : Using VFP 5.0
Edit box is used for entering Description, Quantity, rate & amount fields.
Edit box uses Arial font.


Invice.dbf
invoice_no c 15
invoice_dt d 8
Party_code c 10
Itm_desc m 4
Qty_desc m 4
Rate_desc m 4
Amt_desc m 4

Inv_det.dbf
invoice_no c 15
invoice_dt d 8
Itm_code c 10
qty i 4
Rate n 10 2
Amt n 12 2

Items.dbf
Itm_code c 10
Itm_desc m 4