multiple records acceptance

[chintupintu03]

Hello all,

I want to try out "master/detail" sort of entry form. For a particular work order, user has to enter multiple requirements.

For example, work order number is 1 (one) [ The corresponding field can be set to auto-increment ]

For this work order user has to put

item_code quantity no_of_days

There will be two different tables to store the information. One table will have single entry for work order number, the date of order generated etc. The second table will have the work order number ( asforeign key), item_code, quantity, no_of_days etc.

This may have multiple entries for some cases. How to create set of three text boxes ( for above three fields mentioned) run-time? Or is there any other method for handling such case?

While displaying this record ( or any searched record by user), how to retrieve the information from multiple tables and display on the screen?)

Can anybody forward link where this kind of case is used?

[PallaviDalvi]

ur problem of runtime creation of textboxes can be solved as
var txt=document.createElement("<INPUT type=textbox value=hi id=chk size=20 >");
document.body.appendChild(txt);

this will dynamically append a text box... similarly u can dynamically create as many controls as u want.

retrieveing of data cud also be handled in the same way...i.e depending on the number of records retrieved u cud keep on creating controls.

hope this info helped u.