import a lookup field that is number type

[gharden]

I am trying to import an exact copy of a table from one Access db to another,
but one field won't transfer b/c it's a lookup field. As such, its data type
is Number, but of course, it looks up & displays text. So I get a type
mismatch error.

For example, the field is Product Id & looks up the product name & number
from the Product table, but it only displays the name in the lookup field. Of
course, to be a lookup field, its data type has to be a number.

When I try to either copy & paste or import, or append, I can't get past the
fact that the data is in text format, when I'm trying to add it to a number
field.

What do I need to do to get this data to transfer between these two tables?

thanks, gina

 

[Nikos Yannacopoulos]

Gina,

Have a look at the following link on the evils of lookup fields:

www.mvps.org/access/lookupfields.htm

See anything you recognize? I thought you would!

Solution: remove the lookup fields. You don't need them to begin with,
users are only meant to work with data in forms, not in the tables. So,
lookups belong in forms only, not in the tables.

HTH,
Nikos