Suppose I have a "car" and "maker" table. A car has one maker_id.
Car 2222 has maker_id 1234.
I would suggest that when I right-click on the "1234" of the maker_id of the car 2222 there would be a "Go to record" menu item, and HeidiSQL would then open a new query tab with "select * from maker where id = 1234", so I can have a quick one-time read of an item, instead of using joins.
It's alrealy software nevertheless.
Cheers!