Hi Craig
So far I have manged to everything working but the update record behaviour. I applied an update record behaviour to my page to update the value of the column to 1 but it does not seem to work.
I think the problem is the trigger. I am not sure what to set it to as there is no form element on my detail page. I have tried using the recordset not empty but that does not work.