[AccessD] Lookup Fields in Table Design

DWUTKA at marlow.com DWUTKA at marlow.com
Fri Mar 26 14:38:59 CST 2004


Well put, three points for the score keeper...that puts you in second place!
LOL

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Bartow
Sent: Friday, March 26, 2004 12:50 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Lookup Fields in Table Design


Charlotte,
You'll find that most people are more strongly opinionated than I am (on
many issues). While I may jest about starting flame wars, I really don't
enjoy seeing people argue. However, I do enjoy seeing people debate an
issue. Especially a group with as intelligent and capable people as we have
here. There are many lists where one gets chastised for not conforming to
the group mentality (most generally the "bully" of the group's mentality)- I
don't stick around those lists very long - not because I can't take getting
chastised but because there is really not much one can learn from people who
think they have all of the answers for all eternity! And there is certainly
little opportunity for me to "help" anyone in that situation. I do try to
give back what I can on any list I am on (including directing people to this
list).

I question the status quo.
I listen to all sides of an issue (and there are usually more than two
sides).
I make a decision.
I recommend things based on informed decisions.
I accept that not everyone is going to take my recommendations.
I revisit my decisions on a regular basis to see if there are compelling
reasons to change them.

I believe this is why I am a very good "consultant".

John
PS: We'll just leave my capabilities as a "programmer" out of it!
;o)


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


John,

You are NOT getting into the spirit of this discussion.  Reasonableness
has no place here! <VBG>

Charlotte Foust

-----Original Message-----
From: John Bartow [mailto:john at winhaven.net]
Sent: Friday, March 26, 2004 10:00 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Lookup Fields in Table Design


Here's a stretch but...
For people that like to use the added form designing capabilites of the
lookup property, once the table design and realtionships are complete
you could set the desired lookup properties. Design all of the forms for
the application. When the application design is complete you could run
code that iterates the table collection and eliminates all lookup
properties in the table design. This in essence would eliminate the
corruption and performance issues.

Eh?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Friday, March 26, 2004 11:39 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Lookup Fields in Table Design


There is also the issue of TableID limits, which I believe include all
the tables involved as lookups.

Charlotte Foust


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


-- 
_______________________________________________
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