[AccessD] Lookup Fields in Table Design

DWUTKA at marlow.com DWUTKA at marlow.com
Thu Mar 25 16:39:59 CST 2004


Exactly.  The advantages of them in table datasheet views is just a perk.
I've always viewed them as a way of saving time when building my forms too!

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Thursday, March 25, 2004 4: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