Functions and Triggers

<p><font face="Verdana" size="2">Is there anyone that can point me into the right direction for creating a function and
triggerthat will do something along these lines:</font><p><font face="Verdana" size="2">I have a table that has router
cardtypes and a status on them:</font><p><font face="Verdana" size="2">TEST_RECORD</font><br /><font face="Verdana"
size="2">       CARD                            STATUS</font><br /><font face="Verdana" size="2">1.      er16-04
               0 </font><br /><font face="Verdana" size="2">2.      er16-04 er16-08         1</font><br /><font
face="Verdana"size="2">3.      ssr8000 ssr8600         0</font><br /><font face="Verdana" size="2">4.      er16-04
               1</font><br /><font face="Verdana" size="2">5.      er16-04 ssr8600         0</font><br /><font
face="Verdana"size="2">6.      er-16-04                        1</font><p><font face="Verdana" size="2">I need a
triggerwith a function that will check the card type and status and from there determine the over all status of the
testin the test_table.  Each tuple represents one test on a specific card(s) and the status is pass or fail.
</font><p><fontface="Verdana" size="2">Here the overall status that would be updated in the test_table status be fail,
becauseof the ssr8600 on line 5.</font><p><font face="Verdana" size="2">I appreciate any suggestions and/or
comments.</font><p><fontface="Arial"> </font><br /><font face="Arial"> </font><br /><b><font face="Verdana"
size="2">RAYHUNTER</font></b><br /><font face="Verdana" size="2">Automated Test Group</font><br /><font face="Verdana"
size="2">SoftwareSupport Engineer</font><br /><font face="Arial"> </font><br /><b><font face="Verdana"
size="2">ENTERASYSNETWORKS</font></b><br /><font face="Arial"> </font><br /><font face="Verdana" size="2">Internal:    
53888</font><br/><font face="Verdana" size="2">Phone:       801 887-9888</font><br /><font face="Verdana"
size="2">Fax:         801 972-5789</font><br /><font face="Verdana" size="2">Cellular:      801 698-0622</font><br
/><fontface="Verdana" size="2">E-mail:      <u> </u></font><u><font color="#0000FF" face="Verdana"
size="2">rhunter@enterasys.com</font></u><br/><font face="Arial"> </font><br /><u><font color="#0000FF" face="Verdana"
size="2">www.enterasys.com</font></u><br/>