lookup field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have created an update query in order to update all 25000 records of a particular field.

the field is a lookup field to another table and i have limited the options to be selected (table design, query statement) by setting up certain criteria to another field of the original table.

it is also a required field and the relationship between the two tables is one-to-many.

the update query doesn't work. is this because it is a lookup field an i have to select the value? how can i select the value in the update to field?
 
Angie

If you are saying that you have a table with a field that has been defined
as a "lookup" data type, then that may be your problem. Although
well-intentioned, the "lookup" data type causes considerable confusion,
since what it shows (the looked up value) is NOT what it stores (the
underlying key value).

If this matches your situation, you'll need to either do the update using
the respective key value, or, to prevent having to remember this again (and
again, and ...), you could modify the table and get rid of the lookup data
type, converting it to whatever compatible field type is needed to store the
key data from the lookup. Then, don't use the table to display data! Use a
form, and use a combo box on the form to do the lookup.
 
Back
Top