Foreign key lookup list

[jaxhax]

I am trying to understand how the foreign key lookup list works.

The help says:

"A Lookup list will be displayed for columns with a foreign key constraint to small tables of less than 1000 rows."

For the table I am working on now, it only seems to work if the reference table is 500 rows or smaller.

A related question is how does it decide what columns to display when the lookup list is displayed?

I am using version 9.0.6.1665.

Thanks, Jack

 

[Marco Kalter]

For the table I am working on now, it only seems to work if the reference table is 500 rows or smaller.

It should be 1000. Note that there are some additional requirements for this to work:

• The foreign key constraint can only have 1 column.
• The foreign key constraint must be enabled.
• You need select privileges for the referenced table

A related question is how does it decide what columns to display when the lookup list is displayed?

It displays the primary key column and the first 2 columns of the referenced table.