Lookup table

J

jerry

Access 2003
I have a table that I have imported from excel. There are over 30,000
records in the table. There is a column called shift that has 3
entires, Day, Swing, Grave. I created a lookup table however this
removes and replaces the values in the column to nothing. I could leave
the table the way it is but I would prefer to limit the user to the
choices I offer. What is the easiest way to place the information in
the column without having to go through the whole table. In excel you
simply copy and paste however I have no found a way to paste into
multiple fields.

TIA
 
J

John Vinson

Access 2003
I have a table that I have imported from excel. There are over 30,000
records in the table. There is a column called shift that has 3
entires, Day, Swing, Grave. I created a lookup table however this
removes and replaces the values in the column to nothing. I could leave
the table the way it is but I would prefer to limit the user to the
choices I offer. What is the easiest way to place the information in
the column without having to go through the whole table. In excel you
simply copy and paste however I have no found a way to paste into
multiple fields.

TIA
Click to expand...

Excel and Access ARE DIFFERENT PROGRAMS. Applying Excel techniques and
logic to your database is a recipe for trouble!

Use a Form to update your table. Table datasheets are of VERY limited
utility; forms are much more powerful and more flexible.

On the Form, create a Combo Box using the combo wizard. Choose the
option "use a list of values", and type in Day, Swing, Grave. Choose
the option "store this value in a field" and select the Shift.

John W. Vinson[MVP]
 
Top