Don't generalise relationships like this.

What will happen to your relationship if, for example, you later want to add attributes like "Competitor Lead Consultant", or "Opportunity Partnership Contribution", where those attributes...

Thank you for your reply, Sushila.

The default database is (and should be) set to Master in this case, because most of our users require access to more than one application...