Greeting experts...
Greeting Experts,
Currenly i am developing a simple timesheet system.
And have no idea how to create the below search and update function:
The purpose of the time sheet
1) developer fillup own timesheet
2) catch the developers who rewrite or does not remeber thier own time sheet.
Hence, project owner does not want display any autofillup and display prevoius information.
Attach the layout. It having radio button. "New" and "Add" option.
When the user key in the timesheet date and choose "New" and click the submit button , the new record goes into the database into database as:
Created Date || TimeSheet Date || Project Code || Hours Spend || Tag Date -------------> original
....13/09/11..||.....13/09/11........||......ASK123.....||......8............ ..||...NULL
If the user key in timesheet date and choose "Add" and click submit button, than the function able to go thourht the databse find the old record and update the "Tag Date" as:
Created Date || TimeSheet Date || Project Code || Hours Spend || Tag Date -------------> original
....13/09/11..||.....13/09/11........||......ASK123.....||......8............ ..||...21/09/11
And at same time create new row of record as:
Created Date || TimeSheet Date || Project Code || Hours Spend || Tag Date
...21/09/11..||.....13/09/11........||......ASK123.....||......8............ ..||...NULL