After taking part in the ‘now infamous’ Success Community post about Junction Objects, kicked off by Robert Strunk’s awesome blog post of the same name, it became clear to me that the idea of junction objects is, well, a bit unclear!

So I decided to break it down, Salesforce Rock style:

Custom Junction, what’s your function?
Hooking up records with a custom object!
Custom Junction, how’s that function?
I got 2 set of objects and I need to connect them.
Custom Junction, what’s their function?
With a lookup to A and a lookup to B it’ll get you far!

“Lookup”: That’s a field type, like “date/time” or “text”.
Boom!
It links to another object,
Not this but that.
And then you create another
Lookup, and you have a link!
Between “This” and “that”.
A custom object and two lookups,
Get you pretty far.

Custom Junction, what’s your function?
Hooking up two objects and relating them right:
Classes & Students, Jobs and seekers, leads and campaigns. Hey that’s not lame!

Tickets for concerts, products I’m buying,

A simple object will do: not one lookup but two,
Master-detail is great, but it restricts you, Boo-hoo-hoo-hoo-hoo-hoo-hoo!

Custom Junction, what’s your function?
Hooking up records with a custom object!
Custom Junction, how’s that function?
I got 2 set of objects and I need to connect them.
Custom Junction, what’s their function?
With a lookup to A and a lookup to B it’ll get you far!
Custom Junction, watch that function.
I’m going to get you there if you’re very careful.
Custom Junction, what’s your function?
I’m going to get you there if you’re very careful.
Custom Junction, what’s your function?
I’m going to get you there if you’re very careful.