After I click on an entity key or a foreign key, then the view details option, a details modal appears, but there the foreign keys are not links, so we cannot go through quickly across several tables to look up data. Is there a way to make it clickable, or is there a workaround?
Unfortunatelly no, every table has only one Entity key, and several Foreign Key.
What I found, is that in early Metabase versions if I click onto an entity key, then it opens up the details on a new page, where the keys are actually links:
But with newer versions, it opens up as a preview modal instead of on a new page, and in the preview the keys are not clickable. If I select visualization > details on newer versions, that still goes to the same view as older versions, and the links are working there, but that's not a solution if you have several rows in a table.
So maybe it would be a solution if it could be set to open the details in a new page instead of in modal when clicking on the key, but I couldn't find such a setting.