question

there is a page in my project named '"Member deactivation" in which in select member and their current status from membermster table.Suppose current status is Active and i want to convert it to the Inactive while pressing the deactivate button firstly these records are inserting in the memberledger table, here a column named Authorized is available in memberledger table when I pressed the deactivate button and i have the Admin rights then Authorized column will be update as 'Y' else it will be 'N'. I want a trigger on membermaster , whenever i got authorized='Y' in memberledger then the 'newstatus' ahould be update in the membermaster as current status. Please help me to perform this.