function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
sundalesundale 

Link 2 Account object instances with 1 custom object

What is the best way to relate 2 existing Account object instances (2 different SIDs in the standard Account Object) with 1 Custom object? 

 

Our current stamp trading application tracks people wanting to buy stamps (Account Record Type:  Buyer) and people wanting to sell stamps (Account Record Type:  Seller).  We have a Sold custom object in which we manually record the the buyer and seller names for each completed transaction.  

 

I'd like formally link the Account and Sold objects.  There are 1,000s of buyers / sellers, so the UI to "pick" which ones to match is another concern.  

 

Any ideas?  Thx.

*werewolf**werewolf*

Well, it sounds like what you would want to do is make 2 lookups (or even 2 master-details) from the Sold record to the Account record -- one called "Buyer Account" and the other called "Seller Account."  Then you'd automatically get a related list on the account showing records where that account is the seller and records where that account is the buyer.