Quote Originally Posted by davey23uk
You do realise that your trigger doesnt actually do anything dont you - it just selects the information?
It is "Before" event trigger. The select statement assigns values into :New.Field_Name. It will be stored in table know !!!