append querry with lookup table

[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

 

[James Goodman]

Does this relate to normalisation of data, whereby she has denormalised data
which she wants to import into a normalised db?

 

[Craig]

:> No

Does this relate to normalisation of data, whereby she has denormalised data
which she wants to import into a normalised db?

 

[John Vinson]

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

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.

 

[James Goodman]

So what is she trying to do? Can you give table & column names?