[AccessD] The 10 commandments Access style question?

Hi Shamil and Joe

I still don't like them in tables. In queries, however, they can be quite useful, leaving the table design clean. 

I've used them in a set of queries for simple administrative purposes (configuration of an app) where an ID is exactly meaningless while "the meaning" is mandatory to perform the task. It saved my for creating a bunch of forms.

However, I would never use them in an application at the user level.

/gustav

>>> shamil at users.mns.ru 21-02-2006 10:39 >>>
Joe,

I'd disagree with them and I'd use lookups as much as possible - lookups are 
true development speed up feature and are very useful for users IMO.

I did read carefully the article they refer to 
http://www.mvps.org/access/lookupfields.htm 

Honestly I didn't like to use lookup fields when they appeared in Access 97 
and I even recommended to not use them to some people  - I changed my mind 
for quite some time now - good evolution IMO :)

HTH,
Shamil