I have a 2 database tables; Accounts and Venues
In the Accounts DB is a link to the the venues
In the Venues DB is a link to the Account
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.