Multi-table lookups, are now finally live (Preview) for use via API or SDK. Multi-table lookups (polymorphic lookups) allow the creation of a lookup in one table that looks up records in multiple other tables at once. This provides much greater flexibility in retrieving data within your environments.
Let’s imagine we have many different objects that are in different formats but have the same name. For example we have Books, Audio, Video and Pictures. Creating a multi-table lookup called mt_MultiMedia that has 1:M relationships all to these individuals mt_Pictures, mt_Audio, mt_Books and mt_Video will result in a mt_MultiMedia lookup table provides the records stored in individual tables.
new_Media lookup table
PrimaryID
PrimaryName
RelatedID
Related Name
<multimedia1>
MediaObjectOne
<books1>
Media1
< multimedia2>
MediaObjectTwo
<audio1>
Media1
< multimedia3>
MediaObjectThree
<video1>
Media1
< multimedia4>
MediaObjectFour
<pictures1>
Media2
mt_Books table
PrimaryID
PrimaryName
ISBNNUMBER
<books1>
Media1
1ww-3452
<books2>
Media2
a4e-87hw
mt_Auido table
PrimaryID
PrimaryName
Codec
<audio1>
Media1
mp4
<audio2>
Media2
wma
mt_Video table
PrimaryID
PrimaryName
codec
<video1>
Media1
wmv
<video2>
Media2
avi
mt_Pictures table
PrimaryID
PrimaryName
pıctureformat
<picture1>
Media2
jpg
<picture2>
Media3
png
The Multimedia look up can return records across all the tables in the polymorphic lookup.
A lookup on Multimedia with the name Media1 would retrieve records for <video1>, <books1> and <audio1> .
A lookup on Multimedia of Media3 would retrieve records for <picture2>.