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...