Functions and Triggers

<br /><p><font face="Verdana" size="2">I need help on creating a sql function that will check four rows in a table
basedon that check it will update another row on a different table.  I want to use this function in a trigger
statement.</font><p><u><fontface="Verdana" size="2">Table 1 (Test Type)</font></u><br /><font face="Verdana"
size="2">id     cat     sub-cat test            status          timestamp</font><p><u><font face="Verdana"
size="2">Table2 (Record)</font></u><br /><font face="Verdana" size="2">timestamp       card    comp_date      
status</font><br/><p><font face="Verdana" size="2">What I am trying to do is when someone enters data in on table 2 the
triggerwill verifty the record and then look at all records with the same id and card type, then it will determine the
statusof the test, or in other words it will change the value of status in table 1.</font><p><font face="Verdana"
size="2">Thanks,</font><fontface="Arial"> </font><br /><font face="Arial"> </font><br /><font face="Arial"> </font><br
/><fontface="Arial"> </font><br /><b><font face="Verdana" size="2">RAY HUNTER</font></b><br /><font face="Verdana"
size="2">AutomatedTest Group</font><br /><font face="Arial"> </font><br /><b><font face="Verdana" size="2">ENTERASYS
NETWORKS</font></b><br/><font face="Arial"> </font><br /><font face="Verdana" size="2">E-mail:      </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>