I have three tables (A,B & C). C gets refreshed every 15 minutes.
If a new record is added, both A & B will be effected. If an IDcode isn't in those files it must insert a new record - it will have several columns in each table that would be completed. If the IDcode is already there, it updates those columns.
Can you get me started with a procedure? a trigger? the code? I'm not sure where to start.
THANKS
If a new record is added, both A & B will be effected. If an IDcode isn't in those files it must insert a new record - it will have several columns in each table that would be completed. If the IDcode is already there, it updates those columns.
Can you get me started with a procedure? a trigger? the code? I'm not sure where to start.
THANKS