Transferring values of a field from a table to another based on common key applying a trigger,
As per the screenshot below, I wanted to transfer the values of “enabled” field from T1 table (stored in h.mdf file) to “L1” Layer (stored in m.mdf file) based on the common filed “Ref_S” field. The idea behind is to write the values of T1 into L1 and thus the relation is supposed to be dynamic such that the changes in T1 will be transferred in the real time to L1 so that the values can be represented in terms of map. However, in this case, I’m not sure if the trigger will be directed to the L1 that is under “Table” folder or the one that is under “View”.
I would appreciate if anyone can help me out in writing the trigger.