Design form question:Online form with multiple text boxes for meter No and MeterIN/OUT selection boxes. When user submits with info filled then the records should be there in db for each the meterNo
Posted on 2004-04-16
The online form will allow employees to enter the meter information.
Employee will enter EmployeeID, Select region from drop down, Select dates from dropdown, and enter Meter No and select MeterIN/OUT(sometime employee will have 20 meters at a time and they have to enter meter no's and select MeterIN/OUT.) with same Employee ID and region information.
My suggestion was to give 5 text boxes for the Meter No's and and Selection for MeterIN/OUT.
If they have more, They will load 2nd time form and enter employee Id , region,dates and meterno's
Please help me , if you have any better ideas to perform this requirement succesfully.
I have to create a new form and new database. I will appreciate, if you can give datbase suggestion also. I am thinking of Access database. Please help me with database structure for the feilds.
Please give me suggestions, How to design the form and database with this kind of requirement.
I will really appreciate your help on this