Importing to a Lookup field

  • Thread starter Thread starter John M.
  • Start date Start date
J

John M.

I haven't had any luck importing to a field that is set up as a lookup field
with a series list in a text box. I know I am importing a value that is in
the list. Any idea on the rules underlying this?
 
What are you trying to import into the field: the text, or the numeric
value? While it may look as though the field contains text, it actually
contains a number (assuming that the primary key of the related table is a
number)

You might be interested in reading
http://www.mvps.org/access/lookupfields.htm at "The Access Web" for some of
the many reasons why most of us abhor lookup fields.
 
I was attempting to import text. If i go away from the Lookup values, should
I use some validation rules? I want very specific items in that field. Could
this explain the subscript out of range error?
 
You should still have the two tables, and still have a relation between
them, with referential integrity set. In that way, you won't be able to add
a value that's not in the second table. The concept of lookup table is still
valid: it's just the implementation of it through a lookup field that we
object to.

There's really no way for me to comment on whether that's the cause of your
error though.
 
Back
Top