I've multiple tables that contains different data. Some fields appear in other tables and are based on eachother. How could I allow it to be when I update area A in table A the attached area in table C instantly updates too?
Thanks ahead of time
You have to create or update the FK to Cascade the modification
FOREIGN KEY (parent_id) REFERENCES parent(id) ON UPDATE CASCADE
For additional begin to see the documentation on FOREIGN KEY Constraints