>I am trying to create a Hire Purchase monitoring program.
>
>To make it simple, the following are the tasks which I wish to accomplish.
>
>1) Create a form with textbox field for the user to enter the number of months for hire purchase.
>
>2) Another textbox field for date start
>
>3) A sets of 48 rows of textbox fields to dsiplay the history payments
>
>row1 textbox1 textbox2 textbox3 textbox3
> (date due) (date paid) (amount paid) (reciept no.)
>
>row2 ...etc
>
>The problem is that I don't know how to have a table for the task no.3
>I want to have the textboxs shows the history payments. I am not sure how to go about it.
>
>Hope I am not being too confussing.
Rather than trying to do this in a single table, why not have a parent table of purchases, with a child table of payments for the purchase, each record of the child table containing the fields needed; a parent/child form with a grid for payment details would seem to solve the problem neatly.