Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact
Finderr

-2989 The column name is a reference column, but it is not indexed.

It is recommended that reference columns be indexed for lookups. Performance will be much improved by creating an index.

You have defined the indicated column as a reference column using the LOOKUP attribute. Whenever the operator enters a value in the field, it will be looked up in this column. Such a lookup operation is quick when an index is present, but no index on the column exists at this time. Without one, a lookup might be extremely slow. Unless the field does not allow operator input (in which case you should remove the asterisk) or the table is very small (a few dozen rows at most), you should create an index for this column before you put the form into use.