|I know of businesses where each sales person has their own ID number.|
Bob - SP6
Sue - SP7
If Bob and Sue will share a deal, a new number is created:
Bob & Sue - SP8
Every deal they do together goes into the shared number.
On their internal systems, Bob can see the data for SP6 and SP8 and Sue can see the data for SP7 and SP8. That way their individual business is kept completely separate from their joint business and there is no confusion or conflicts.
To take it one step further, contracts can be written and signed by both Bob and Sue as to how on-going commissions, referrals, etc. will be handled for any deals done under SP8.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.