[AccessD] The 10 commandments Access style question?

We've had this little debate before.  Are we trying to liven this week up a
bit or something?

Drew

-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk]
Sent: Tuesday, February 21, 2006 4:17 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com