Lookup field in table

[Lars Brownies]

I know I shouldn't use lookupfields in tables. But does that also accounts
for when you create a lookup in a field's table from a 'list of values'? For
instance I want to create a lookup field for the field gender with values
"M" and "F".

Thanks, Lars

 

[Arvin Meyer [MVP]]

Do it in a value list in a combo box in your form.

Users should NEVER see tables.

 

[Lars Brownies]

Users should NEVER see tables.

I agree, but that was not my point. If you set the value list lookup in the
table, the combo automatically appears whenever you put the field on any
form.

Lars

 

[Arvin Meyer [MVP]]

It takes less than a minute to add a combobox to a form. If you had 20 or 30
or more based on this field you might have a point. Five years from now, you
or your successor will spend more than 20 minutes fixing things because it
isn't clear how you've done it. That said, classically a table is used to
store data, and maintain its integrity. How does this accomplish either of
those goals?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

 

[Lars Brownies]

I missed that point. Thanks for explanation.

Lars