Hello,
Sometime you have many relationships in a table, and you need to insert data. It becomes a painful task when you constantly have to go check the ids of your parent rows for each foreign keys.
Is there a tool that make this task easier, by allowing me to do a kind of ajax search for ids while I am inserting data?
For exemple, if I would add a message, I would do an "ajax search" for the author "Steve". and it would return a list of authors with the name "Steve" along with their id and other columns. I could then choose the right one and the id would be added to the field.
If it doesnt exists, is there a way to hack/patch phpmyadmin to add this feature. Has it been done before?
Thank you