<br />Here is the question:<br /><br />I have a situation where I need to create triggers to cascade an insert
operationto many tables to maintain foreign key constraints. <br /><br />So at a high level<br /><br />INSERT INTO
myTable(Name, Address, Zip) VALUES ('Mark', '3 Dingle St.', '01832') <br /><br />myTable has a relation to two other
tables,which contain Zip and Address. Before I insert into myTable I want to:<br /><br />Check if '3 Dingle St.'
existsin table Address, if not insert it<br />Check if '01832' exists in table Zip and if not insert it <br /><br />I
wantto generalize this so that for any insert into myTable, I guarantee that if Zip and Address are not populated they
willbe. My insert into myTable always contains full information required for doing the inserts into the other related
tables.<br /><br />Help?<br /><br />--Mark<br /><br />