PhpMyAdmin does something similar to "lookup Wizard" in MS ACCESS?
For those who don't know what the lookup wizard, I will describe.
Suppose we have three tables:
In the Posts table there are two fields:
In the People table there are two fields:
The table's two fields:
1. Human code.
2. Code posts.
I can make the table Employees instead of entering codes (Code and Code positions), you could choose the name of the person and the name of the position - using the drop-down list. I see your name, and inserted Code. I see the name of the position and the substituted position ID. Codes I can't see, but they are substituted.
In MS ACCESS this is called "lookup Wizard". It is called in constructure table when you specify a data type for a table field (with him are still the relationship between the tables. It is logical).