What is the best way to connect Opportunity and related Quotes to multiple Accounts? We would like to track each of the accounts separately on the Quote with a status (bidding, not bidding, not reviewed, etc). And on the Account page we should should be able to see all related Opportunity and Quotes. Eventually, we need to be able to close a Quote by selecting a winning Account.
Currently we are just adding 10 lookup fields to Opportunity and Quote entities and updating those manually by revising an activated quote> changing the parent account to the winning account> activating it>closing Quote as won. Most of the users don't revise the quote and close it without updating the winning account as the parent account. That is because doing so is very cumbersome and does not provide a great user experience. There should be a better way to accomplish this. Please advise.