Is there a way to build a trigger (add,update) that will look up a foreign key from a code table? Example - table a has columns genkey and source code, where genkey is a generated key based on a sequence number and source code is some data that the user is expecting. Table b has the column genkey and when data is added,updated need to find genkey value in table a by using source code which is available in the input data. This is for an oracle application.
thanks for any help.