Use a lookup field, or lookup table?

[Ricter]

What's wiser, use the lookup wizard for a field and enter the three values I
want to offer users, or create a combo box and lookup the values from a
seperate table?

 

[Van T. Dinh]

It is much more flexible to use a LookUp Table unless you know for sure that
you will never need more than the 3 possible choines you are aware of.

 

[John Vinson]

What's wiser, use the lookup wizard for a field and enter the three values I
want to offer users, or create a combo box and lookup the values from a
seperate table?

Neither.

Users should never see table datasheets, with or without lookup
fields.

Use a Form; on the Form you can put a combo box. It can be based on a
List of Values or a table as you see fit; the advantage of a table is
that it is easier to edit (say, to add a fourth value or change the
content of one of the values). The advantage of a Value List is that
it clutters your database less.

John W. Vinson[MVP]