Confusion about lookups/value list

[Guest]

I hate to sound like an idiot, but oh man am I confused!

Everywhere on here it says don’t use lookup fields, but then the info on
http://office.microsoft.com/en-us/access/HA101637731033.aspx tells me how to
do it, but “wrong†according to the MVPs (am I understanding that right?)

I originally started looking here to find the answer to this (simple?)
question:
For static, “non-data†lists such as Mr, Ms, Mrs, Dr., Rev, etc. (which I
was taught is a value list, not a lookup), which lookup is better to use, a
separate 2 column table that contains the info or a value list I type
directly into the wizard?

If I understand correctly, in this limited example, I should have two
tables, one for the prefix, as mentioned above, and a separate table listing
contact names (first, mid, last) with a foreign key to the prefix table.
Relate the tables, write a query to include both tables, and then base a data
entry form on that query. In order to have a drop list appear for the
prefixes of Mr, Ms, etc., I use a combo box on the form and I never really
use the “lookup†function at all.

Is that correct?

Christine

 

[George Hepworth]

There are probably as many answers to this question as there are
experts.....

 

[UpRider]

Simplest way is to use a value list. No lookup table. Just store the value
in the combo box in a table column, same as the name you are entering.

UpRider