|
|
Posted by Jchick on 06/02/06 23:08
Im a newbie with a sql table in a MSDE database that contains fields of
CustName, BrokerName, Type, Status.
I am trying to write a trigger that does this:
1. When a new record in a table is added, I would like the selected
fields to be copied to another table (call it Master).
2. If that Master table already contains a record where the CustName =
CustName, then simply ignore. If CustName does not match anything, then
add the record to the Master Table
In other words, I am trying to create a table (or even a new database)
that has unique records in it - making a master customer list.
Any hints on how to get started on this?
Navigation:
[Reply to this message]
|