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

-2920 The column column is a dominant column but it is not indexed.

Performance will be much improved by creating an index on the column.

You have defined the indicated column as dominant in a verify join. Whenever the operator enters a value in the field, it will be looked up in this column. Such a lookup operation is very quick when an index is present. 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.