Lookup problems

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

Guest

Hi, I have created a table that has links to three lookup tables. Each of these has an index and the required field. When I view the data in the table there is no problem, ie I can see the words I want to see (rather than the index id). In the Look up properties, it says 2 columns, 0;2.54cm. So far, so good!

But the problems occur when I view this in a form. It only shows the id number in the form, and even if I change the properties to show 2 columns with 0;2.54, as above, I can only see the ID. It is SO frustrating!!

What is worse, I have parameter queries as the base to my reports, and these now won't work, basically because I am putting the word in the parameter, and it must be looking for the number! I feel like such an idiot, but hope you can help me

Thanks. Nero.
 
You've run into one of the problems with using the "lookup" data field type
in an Access question (well, actually, you've run into two or three).

The lookup data type STORES the look-up key value, but DISPLAYS the
looked-up text value. Any chance for confusion there?!

The solution is to change those lookup fields to their appropriate numeric
or text types, and use queries to link to the lookup tables for display
values.

Use combo boxes in your forms that are based on the lookup table -- you can
still bind the control to the underlying foreign key field in your main
table.
 
Back
Top