How Records Are Matched
The relationship compares a Source Key with a Related Key on the related object.- Standard uses an existing Salesforce lookup or master-detail relationship. The source key is the source record’s
Id. - Custom compares fields you choose, even when no Salesforce relationship connects the objects. The fields must have compatible types.
Account.AccountNumber with Order.CustomerCode__c. Matching uses equality, not a partial text search. Source keys use saved Salesforce values and do not need to be visible columns.
Choose Source Rows
New unsaved rows are excluded. Duplicate source keys are combined and empty source keys are ignored.
Choose a Match Type
- Matching displays records whose related key equals any usable source key. This is the default.
- Non-matching displays records whose related key equals none of the source keys, including records with an empty related key.