I am adding some foreign relations in phpMyAdmin to make data more easily accessible when adding rows. How can I make the foreign relation value stay as is (ex. ad6c68d9c365364f437e4a569765de2e) but make the text show the more readable 'name' value of the linked table?
Here is what it looks like now:
I want the calling value to show something like 'junior', the name value of the displayed data, but I want the value to remain as is.