Forum Academy Marketplace Showcase Pricing Features

Linking 2 database tables through autobinding (or any other method)

I have a 2 database tables; Accounts and Venues

In the Accounts DB is a link to the the venues
image
In the Venues DB is a link to the Account
image

I have a page to edit the Venue information with a dropdown to assign that Venue to an Account. When I do this, I am successfully applying the change to the Venue DB but it’s not being updated on the Account DB table. How can I do both? Am I doing this wrong?

More details on my application. This is a database of business accounts and I need an Account information page then under that I need to display the Venue(s) associated with that account but I need to be able to make those changes on both tables.