problem related to database

[biswa47]

i have a table named emp. where one coloumn named "status", which doesnot take any value from the front end.i am storing its default valus as"ON" in the emp table which is set in its cloumn property . and another table emp_detail where one column named "eligible".( both tables are related with each other by "emp_id" coloumn)where it takes the value from the frontend either "Y" or "N".now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF. where it takes the value from the frontend either "Y" or "N". now i want if the value for "eligible" is stored as "Y".then the corresponding record of that in the "emp"table should be updated that is only the "status " column set to be OFF.

[Panchal Hardik]

you can change the status while inseting the data in emp_detail table. Or you can create a triger on emp_detail table on insert and check the eligible column and update emp table as per value Hardik Panchal

[biswa47]

i dont know how to write trigger.but know the storeprocedure,so can let me know howto write the trigger for that

[biswa47]

how cani change the status of the table. can you be little elaborate it. or if possible do write the code .. or the trigger