[SQL] Looking for some help with cascading updates...

[Mark True]

Here is the question:

I have a situation where I need to create triggers to cascade an insert operation to many tables to maintain foreign key constraints. 

So at a high level

INSERT INTO myTable (Name, Address, Zip) VALUES ('Mark', '3 Dingle St.', '01832')

myTable has a relation to two other tables, which contain Zip and Address.  Before I insert into  myTable I want to:

Check if '3 Dingle St.' exists in table Address, if not insert it
Check if '01832' exists in table Zip and if not insert it

I want to generalize this so that for any insert into myTable, I guarantee that if Zip and Address are not populated they will be.  My insert into myTable always contains full information required for doing the inserts into the other related tables.

Help?

--Mark