I have created two tables that rely on the same primary key and linked them. I would like to be able to add a new value to one table, and have that linked column update in the linked table. Is this possible from the datasheet view? I know how to do it using an actual SQL Update Query.
If possible, how do I go about doing this, or what would this be called?