[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.