(Im a newbie at oracle)   
      
      
   I have a field in my database called "gamesplayed" and I would like that to   
   display the total of 'opwin' & 'oplost' automatically. Sort of like adding a   
   formula to a field in excel, but I cant figure out how to do this or if its   
   even possible.   
      
   example:   
      
   'opwin' 9   
   'oplost' 19   
   'gamesplayed' 28 (i would like this field to update automatically)   
      
      
   I am thinking I just add the command "select sum(opwin+oplost) from   
   gametable;" to 'gamesplayed', but how?   
      
      
   Andrew   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)