append querry with lookup table

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I have a user trying to append records using append querry. She cant get
the values to populate the field with the lookup table however. Im sure its
because it is data from another table. Is there a trick to making this
work??

regards

craig
 
Does this relate to normalisation of data, whereby she has denormalised data
which she wants to import into a normalised db?
 
I have a user trying to append records using append querry. She cant get
the values to populate the field with the lookup table however. Im sure its
because it is data from another table. Is there a trick to making this
work??

regards

craig
Click to expand...

Yes; you must append the hidden numeric ID, not the looked-up text
value. This is one of MANY reasons to dislike Microsoft's misdesigned
"Lookup Wizard" - see

http://www.mvps.org/access/lookupfields.htm

for a critique.
 
Back
Top