Menu
▾
▴
#448 FK relation popup DHTML window based on multiple fields
I would like to see a FK popup DHTML window appear
onmouseover FK# event. The DHTML window contents will
be defined in the Relation View page. Instead of a drop
down Choose Field To Display. Have either:
1) Text box which you can enter a query for the FK lookup.
OR
2) Multiple text boxes to select more than one field.
Example 1)
SELECT CONCAT(first_name, ' ' last_name) as Name FROM
contact_tbl WHERE contact_id=#id# ORDER BY Name
The "#id#" would be replaced with the FK id.
OR
Example 2)
DropDown1, DropDown2, DropDown3... etc.
Logged In: YES
user_id=760789
Example 1 with a query can also be used to query more than one
table to build the FK popup.
Example:
SELECT a.first_name, a.last_name, b.email FROM person_tbl a
INNER JOIN address_tbl b ON a.person_id=b.person_id WHERE
person_id=#id#
In regards the the Initial posting: there was an ORDER BY
statement which doesn't make sence if its a PK lookup.
But it leads to another idea:
If you use DHTML popup windows then you can have reverse FK
lookup, the DHTML window can contain a table list of FK values.
Diff:
Duplicate of https://sourceforge.net/p/phpmyadmin/feature-requests/620/