When we are trying to create a lookup field that lets you check out media to the users.
We will have a table of Books with book publilsher details, a table of Audio offerings with audio type, and a table of Video offerings with video type.
There was no easy way to create a lookup that would pull data from all three tables at once.
We may end up with three separate lookups as shown below.
The solution is to have a single lookup, that can search data from all the media tables.
Watch this full video with a demo on this.