I have two tables X and Y, which have corresponding linked record fields. Consequently, if I update a linked record field value in table X, then the update is reflected in table Y. This is expected behavior.
Based on the 2 linked record fields mentioned, I used the ‘Create junction table’ script to create junction table X-Y. The corresponding linked record fields in X and Y are both shown in X-Y as a result. When I…
-
update either of the 2 linked record field values in X-Y, the corresponding values in X and Y are not updated, or when I…
-
update said values in table X or Y, junction table X-Y is not updated.
Is this behavior correct or is there a bug in how I’ve implemented the junction table?