Convert Value List to Lookup Table

T

Tommy D

Greetings

Is there an easy way to convert a value list to a lookup
table in an existing database (without destroying the
original db?

I have a db where the value list is growing and would be
easier to manage as a lookup table.

Any help would be appreciated
 
J

John Vinson

Greetings

Is there an easy way to convert a value list to a lookup
table in an existing database (without destroying the
original db?

I have a db where the value list is growing and would be
easier to manage as a lookup table.

Any help would be appreciated
Click to expand...

Just create a table with one field, of the same datatype as your
current field. Manually type in the values currently in your List of
Values.

Change the Combo Box on your Form so that instead of "List of Values"
it has "Table/Query", and set the Rowsource property to the table
name; or, better, create a query sorting the table alphabetically and
use that.

I would suggest that you do NOT use the "Lookup" datatype in a Table.
Table datasheets are best reserved for debugging, and not used for
data entry; there is no good reason to put a combo box in a Table. Use
a Form instead.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top