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