Hi,
Could someone assist me how to automatically generate rows.
I have 2 tables :
Table1 : id, cust_name, period, date_due, amount
Table2 : id, subid, seq, date_due, date_pay, amount_paid
Table1 record : 1, jack, 12, 15/05/2010, 500
Table2 record:
1, 1, 1, 15/05/2010, 27/05/2010, 500
1, 2, 2...