not getting Import Error table when import .xls to a LimitToList f

T

txmexmissy

Any help/suggestions appreciated: I have a field (BankName) in a table with
the field property set to "Limit To List" (field is a lookup from
table="Bank"). I need to import Excel data on a regular basis into this
existing table, but need to catch Bank Names not equal to "the list".
Previous DBs I've worked on have always caught such errors in an Import
Errors table, but now that I actually want this to happen, it's not. Please
help.
 
Top