[AccessD] Lookup Fields in Table Design

John W. Colby jwcolby at colbyconsulting.com
Thu Mar 25 17:16:12 CST 2004


mine too

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Thursday, March 25, 2004 5:18 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Lookup Fields in Table Design


Lookup fields are bad in forms? That's why they exist -- the controls
automatically inherit the lookup properties. I don't think lookup fields
were ever meant to be a table benefit -- but rather an inherited trait for
controls. At least, that's always been my take on them. 

Susan H. 

And did you try it using *forms*, Drew.  That's what users tend to deal
with, isn't it?  And that's where my experience says they're a bad idea
(well, users are often a bad idea, but I'm talking about lookups.)

As far as your "advantage",  I don't let my users come within a mile of my
tables, so where is the advantage?  They *can't* manually enter records,
period.


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






More information about the AccessD mailing list