Reference Table


I need your help regarding with referenced table. I have here a table1 that is linked to table 2. The expectation is every time I make an update to a specific column in table1; it will automatically update on the equivalent column on table2. Any recommendation on what will I do to achieve this expectation?

When you say that Table 1 is “linked” to Table 2, do you mean that Table 2 is the parent table and Table 1 is the parent table? Currently the M.O. to modify tables with values from other tables is to use the INPUT() function coupled with some actions. See the following elegant description of the process: