Lookup field

[Jimmy]

I have 1 main table that contains information that was imported from Excel.
I want to create a smaller table that has 3 of the fields from the main table
and 3 additional fields that will be data entry type fields. Is there a way
to automatically pull in the 3 fields I want from the main table and have the
data listed in rows like a normal table. I would then create the additional
fields on the smaller table. Everytime I've done the lookup wizard, it puts
all of the rows in the large table in 1 drop down box.

 

[Arvin Meyer [MVP]]

You do not need the smaller table. It is a very bad practice to store the
same data in multiple places. Instead, create a query which includes the
Primary Key and the 3 fields from the table that you want to see.

 

[Jimmy]

How would I add additional fields to that query and still pull the data from
the main table?

 

[Jimmy]

Maybe it's better to give you a little more background:

Monthly, I'll be importing a file that has 20+ columns. I'll also need to
add 3 additional columns that will have a drop-down box with several options.
When I import the next month's data, is it possible to retain the data in
the 3 new columns that is associated with the new records. Client Name would
be the primary field for all future reports, forms, etc. If I have Client A
and in one of the new columns had "active" as the entry for the field, when I
do the next import, will "active" still remain in the new column?

 

[Testy_Tester]

I have 1 main table that contains information that was imported from Excel.
I want to create a smaller table that has 3 of the fields from the main table
and 3 additional fields that will be data entry type fields. Is there a way
to automatically pull in the 3 fields I want from the main table and have the
data listed in rows like a normal table. I would then create the additional
fields on the smaller table. Everytime I've done the lookup wizard, it puts
all of the rows in the large table in 1 drop down box.

 

[Arvin Meyer [MVP]]

Add the 3 columns to the original table and to the query. Output your query
to a form where you will add a combo box to fill the column. The data will
be then written to the original table as you make your choices. If there's
only a few choices that won't change, use a Value List for your combo,
otherwise build a table to make the choices from.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com