Unfortunately QuickBase doesn't have a way natively to affect data on a different table when a separate record is added/edited. It is a strongly requested feature here however:
https://quickbase.uservoice.com/forums/111823-quickbase-product-feedback/suggestions/1904137-quickba.... I recommend adding your vote to this request and hopefully we see this implemented sooner than later. In the mean-time, contacting one of our partners:
http://quickbase.intuit.com/partners would allow them to design a custom script for you to keep the two data sources in sync with each other.