Lookup Fields

Lookups or lookup fields are alternative fields you select to display for a foreign key value, for a singular related object. For instance, each Album keeps an ArtistId in each row. But wouldn’t be better to rather see the artist’s Name walking through that relationship?

Lookup Query Builder

The Track table in the query below shows by default numeric IDs for related information, such as its Album, Media Type and music Genre, which do not tell much:

Query Results with Lookups

Whenever lookups are available, Lookup cells show “(no lookup)” and you may expand and choose another display field. We automatically generate the required SQL joins, to walk through the relationship. And next time you show again the Lookup bar in another query, the lookup field is populated by default. Here is a more friendly alternative view, with lookups, after only a few clicks: