How can I link a column in one table to a column in another table so that any changes on one column will be also occur on the linked column?
You can create a link object to link the selected attribute/column in one table with another attribute/column from the other table. When attributes/columns are linked, changes are synchronized between the objects based on the selected synchronization direction.
For this example we will link the column 'payment_transaction_number' with the column 'employee_ number'.
You can use the Link Wizard to create a link object by taking the following steps:
Therefore, any changes to the source column, such as changing the datatype or column name, will also be changed in the linked column.
NOTE: the synchronization can be one sided (from either the original or linked Column) or for both sides.