Vakues for the look Up Wizard

[Amanda]

alHello,

I have a general question about the lookup wizard when using it to set a
data type in a table.

Will my databse run faster if I have the wizard look up vlaues in an
exisiting table, or if i type in the values I want?

 

[Jerry Whittle]

I doubt that it would make a measureable difference either way.

The biggest decision point on whether to store the values in a table or not
is how written in stone are the values. If they never or very, very seldom
change, a value list would be OK. However if these values can change and were
stored in a value list, you would have to kick everyone out of the database
to modify the table. Were they stored in another table, you could just edit
the records in that table.

FYI: A lot of people avoid lookups at table level. They can cause confusion.
I almost alway create combo boxes or list boxes in forms that are based on
tables instead. Check out the links below to see why some people consider
table-level lookup fields evil.

http://www.mvps.org/access/lookupfields.htm

Further check out the second commandment here:

http://www.mvps.org/access/tencommandments.htm