[AccessD] Lookup Fields in Table Design

I started the thread decidely not using lookup properties for the past 5
years because of the overwhelming attitude among developers that it
shouldn't be used. (IIRC that's when I first read Dev's "10 Commandments".)

I had no "side" in this debate other than pointing out weaknesses I saw in
specific arguments (and being "cutesy" at times) Rarely is someone go to
fully switch "sides" in a debate. (So I don't expect everyone to agree with
me.) I believe that, based on this thread, the people who argued that it is
OK to use lookup properties have won the day.

Unless someone comes up with a solid reason why it should never be used I
will not hesitate to use it again when the situation warrants.

I challenge anyone to use facts to convince me otherwise. In fact I would
very much appreciate it. And I'll buy you a few if you can do so!

John "always open to the facts" Bartow


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Monday, March 29, 2004 2:44 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Lookup Fields in Table Design


Forget it.  You insist that your opinion carried the day.  Go right
ahead and believe it, but don't expect everyone else to agree.

Charlotte Foust