Help on VBScript - Parent & Child Table application

Friends,

I need to build an application to maintain some details. Below is the detailed information.

All my data are available on the access db.

Access Table view

emp_no char,
week1 number,
week2 number
.,
.,
week20 number

Form view

emp number : d201
no. of months: 3

WK1 WK2 WK3 WK4 WKTotal Wk1 Wk2 Wk3 Wk4 WKTotal Wk1 Wk2 Wk3 Wk4 WKTotal


Above is a grid or table and the weeks display are dynamic based on the no. of months entered. Consider 4 weeks per month, so the grid should display 3*4, 12 weeks and after every four weeks there should be a total dynamically calculated based on the value entered in the four weeks. On click of a button, we can add rows to the weeks and provide option to enter value for each week.


On click of save it should get saved in the access_table.

this is my requirement, can anyone provide me the code with source code as I need to build an application based the code you helped me with that. Since I have some limitations in the environment dependencies, i should only use vbscript, html and access... no more hifi techs.

I am really grateful...

Thanks
Sam.

Tags: VBScript