Lookup Data in tables

[Robert Gomez]

I've been working on a table which has fields that are of
Lookup type to another table. The purpose is that, when
choosing one item in the form, the item's description and
other related fields are automatically filled because of
the lookup reference. Although this feature works
flawlessly on the form, it does not work for the table.
When I go to the table to view the information I can only
see the first field (the one chosen from the combo box in
the form that makes the other lookup fields appear in the
form). The rest are blank, although when I check the
table and click on the field the combo box does open,
showing all the combo box options. Could anyone help me
with this?? I would really appreciate anyone, since my
project has a deadline due for Monday and this issue is
really giving me a lot of trouble. Thank you very much!!

 

[Duane Hookom]

Before you do much more work on the lookup fields, take a look at
http://www.mvps.org/access/lookupfields.htm.

Many of use don't ever use lookup fields. All data entry and viewing is done
in forms and reports.

 

[Robert Gomez]

IT is true that most data entry and viewing is done in
forms and reports, but I still need the table to create
the queries. To be more specific of my problem, these are
the details of my table: there is a table of different
chemicals which is being referenced by the main table.
This table contains the chemical's name, description,
threshold and threshold unit. I created a form that
references the main table and when I select a specific
chemical from the combo box menu, the chemical
Description, Threshold and Threshold unit fields in the
form are loaded with the information from the Chemicals
table. I know there might be other ways to work around
the problem, but it would involde redesigning the whole
database, since most of it is already done. If there is
no way of displaying these fields in the table, could
they be displayed on a report? I checked the tips from
the MVPS site, but I have no choice but to keep running
the database the way it is, since it would take too long
to redesign it. Could you please give me more ideas on
how to work it out. THanks a whole bunch for your help!

 

[John Vinson]

If there is
no way of displaying these fields in the table, could
they be displayed on a report?

Sure! Base the Report on a Query joining your main table to the lookup
tables. If you're making the (common) assumption that you must have a
Table of data in order to generate a Report on that data, you don't.
Just use a Query.

 

[Tim Ferguson]

I checked the tips from
the MVPS site, but I have no choice but to keep running
the database the way it is, since it would take too long
to redesign it.

"If you ain't got time to do it right, how come you've got the time to do
it wrong..?"


Tim F