SQL Window - Linked Query Dropdown

[Frodo]

When I edit data in the SQL Window I've noticed that some columns (that are linked via a foreign key to another table) will present a dropdown list of the foreign key table with the relevant row selected.

Similar to the Linked Query function but slightly more useful.

But this functionality doesn't happen on every table/column with foreign key references. As far as I can tell it's only tables I've created using PL/SQL developer and I can't find any documentation on this feature in the help files.

Is there a reason why it doesn't always work and if it's not something daft I've done is it likely to be expanded upon in the future?

 

[Marco Kalter]

The foreign key selection list will only display if:

1. The record can be edited.
2. The referenced table is accessible.
3. There is onle 1 foreign key column.

It does not matter how the 2 tables are created, all information is read from the Oracle dictionary.