Hi,
I am a newbie on PHP.
I am designing a timesheet database for my company. I have the a table "timesheet" with following field (timesheetid, employee, empno, workdate, totalhour,unitrate). The unitrate is a field dependent upon the value of `empno` which is linked to a table called "employee" with field (empno,unitrate).
I have two groups, employee and admin.
I create a TimesheetList page consisting of (timesheetid, employee, empno, workdate, totalhour). I also create an Add page in which employee could input their timesheet to the system with the following field (timesheetid, employee, empno, workdate, totalhour).
What I want is that whenever an employee add a record eventhough in the Add page, there's no `unitrate` field, it could automatically add `unitrate` value to the 'timesheet' table. The unitrate will be accesible only by admin through a different page called 'timeadmin ' which consists of the following field "timesheetid, employee, empno, workdate, totalhour,unitrate"
Regards,