Hoping someone can assist with this....when a record is created in tableA, i need a corresponding entry made in tableB, if it does not already exist in TableB. TableB has the AccNo field as a , which is the "create unique" index. Is someone able to assist me in creating a trigger that will act as soon as the tableA record is saved, insert it into tableB, if it does not already exist?
Many many thanks in advance,
ije
PS - this is all on MS SQL 2000 servers..
Many many thanks in advance,
ije
PS - this is all on MS SQL 2000 servers..