<div dir="ltr"><div><div><div><div>Hi all,<br><br></div>I have been working on this feature during the last couple of days and I've sent a pull request [1] containing what I've done.<br><br></div>With the changes the long dropdown to select foreign column has been split to two dropdowns, one to select the foreign table and the other to select the foreign column. I have also extended this to support cross database relations with an additional dropdown to select the foreign database. <br>
<br>So when the user selects the database, the entries in the table dropdown are filtered only to show tables in that database and column dropdown is filtered in a similar manner when a table is selected. Own database is selected by default as it's more common to setup relations inside the same database.<br>
<br></div>Checking relational integrity feature was already supporting cross database relations. I've added table name to the displayed text to make it clearer. I have also updated a couple of FAQs in the documentation related to these features.<br>
<br></div>I would be grateful if you could check out this feature and suggest any improvements.<br clear="all"><div><div><div><div><div><br>[1] <span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);display:inline!important;float:none"> </span><a href="https://github.com/phpmyadmin/phpmyadmin/pull/438" target="_blank" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">https://github.com/phpmyadmin/phpmyadmin/pull/438</a><br>
<br>-- <br><div dir="ltr"><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Regards<br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255)">
Kasun Chathuranga</div></div>
</div></div></div></div></div></div>