I have a feature class related to Table 1 (for illustration purposes) then Table 1 is related to Table 2. The relationship classes are both based on GlobalID to GUID...all datasets are in an SDE environment. Each of the 3 datasets contains the identical field 'Assembly_ID'.
I want the 'Assembly_ID' value to be updated in Table 2 when the feature class field is updated. Currently, I have a functional attribute rule that will update the 'Assembly_ID' field in Table 1 when said field in the feature class is updated. I have another functional rule that will update the 'Assembly_ID' field in Table 2 from said field in Table 1 when some other field is updated in Table 1. I don't want to have to perform an edit/update in Table 1 for the value to pass thru to Table 2.
Is there a way to pass the value directly from the feature class to Table 2 (I DO NOT want to create a relationship between the feature class and Table 2...that field is the only common field between the feature class and Table 2) OR have the value pass from Table 1 to Table 2, passively, without some trigger being activated in Table 1?