append queries

  • Thread starter Thread starter Michael Stengel via AccessMonster.com
  • Start date Start date
M

Michael Stengel via AccessMonster.com

I am trying to append records from and older database to a newly created
one. How to append the old data (one table, all text fields) to new tables
which use "lookups" . other words, need to append the "Hidden numeric ID"
 
I am trying to append records from and older database to a newly created
one. How to append the old data (one table, all text fields) to new tables
which use "lookups" . other words, need to append the "Hidden numeric ID"
Click to expand...

Then you need to append the numeric value.

I would recommend NEVER using lookup fields, or if you do, never at
least hiding the numeric ID's. Table datasheets should be used for
debugging only; it is NOT necessary to have a lookup field in the
Table in order to put combo boxes on Forms.

What you will probably need to do is create the append query by
joining your old text-field containing database to your new "lookup"
tables, joining *by the text value* and picking up the numeric ID from
the lookup table.


John W. Vinson[MVP]
 
Back
Top