lookup fields?!?!

[aaron_kempf]

Hey why does everyone dislike lookup fields so much?

The root of the problem.. is that you guys CAN'T see the data
_WITHOUT_ the lookups, right???

In SQL Server; I can use 2 tools to look at the data _WITHOUT_ Lookup
fields-- so I think that they are the greatest thing since sliced
bread.

Seriously- why are they _SO_ confusing to you MDB kids?

I can query things using Query Analyzer, Enterprise Manager,
Dreamweaver; SQL Server Management Studio.
I can see the data _WITHOUT_LOOKUPS_ when and where I want.

So now _WHY_ is it that lookup fields suck?

I just think that is one of the most ridiculous things I've ever heard
in my life.
Lookup fields are probably the _ONLY_ reason I use MS Access.

HONESTLY.

So here i've got a _SECOND_ solution that makes lookup fields
_INCREDIBLY_ nice to have:
1) make the lookups on the original column
2) make a new 'computed column' that shows the data
3) set the computed column = 'OrderID'
It's not like using a computed column uses any extra resources
4) presto chango- I've got the data with or without lookups- when
and where I want them.

QED

-Aaron

 

[James Woods]

Aaron (or whoever you REALLY are):

You should just go play on the freeway, you jerkwad. You're a piece of crap
that shouldn't be allowed to have a computer. Your knowledge is that of a
retard and we can tell that you have the personality of a slug.

Go f##k yourself as nobody cares about your stupid opinions. So, just JAM
it pin brain!

The world would be a much better place if you suddenly disappeared.

 

[BruceM]

It seems you do not understand lookup fields (as oppsed to lookup tables),
which show you data other than what is being stored. A search will turn up
a lot of discussion about this topic.

 

[a a r o n . k e m p f]

James;

I disagree.

I am one of the only certified people on this newsgroup.

I just disagree with 'lookup fields are evil'.

I always have and I always will.
It honestly blows my mind-- I think that the lookup TAB is probably
the most important reason that I use Access.

-Aaron

 

[a a r o n . k e m p f]

Bruce;

there is no such thing as a 'lookup table'; except in your piece of
crap naming convention.

I understand lookup fields.
I just find it funny that you guys blame the functionality- not the
DB.

It really honestly seems like the only reason not to use them-- is
because you cannot see the plain data.

With ADP; I can programmatically _SEE_ the plain field when and where
I want.
With ADP; I can programmatically _REMOVE_ the lookup fields when and
where I want.

And JET cannot.

Right?

Thanks

-Aaron

 

[BruceM]

I repeat, you don't get it. Anything.

message
Bruce;

there is no such thing as a 'lookup table'; except in your piece of
crap naming convention.

I understand lookup fields.
I just find it funny that you guys blame the functionality- not the
DB.

It really honestly seems like the only reason not to use them-- is
because you cannot see the plain data.

With ADP; I can programmatically _SEE_ the plain field when and where
I want.
With ADP; I can programmatically _REMOVE_ the lookup fields when and
where I want.

And JET cannot.

Right?

Thanks

-Aaron

 

[Jerry Whittle]

I am one of the only certified people on this newsgroup.

What do mental health or unemployment certifications have to do with lookup
fields?

 

[BruceM]

lol

What do mental health or unemployment certifications have to do with
lookup
fields?

 

[James Woods]

"> I am one of the only certified people on this newsgroup."

Yeah, certified LOONEY! You're an a**hole and people don't like what comes
out of those things. You're not wanted here and are just a big troublemaker.
All you do is try to feed sh#t to newbies. The rest of those who know
better know that you are just a blowhard.

So, go take your toys and go play with yourself...

 

[Tony Toews [MVP]]

Aaron (or whoever you REALLY are):

Aaron is, so far these last few weeks, posting under his real name.
Posting under a false name would violate terms of his parole.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

It's not parole you moron

-Aaron

Aaron is, so far these last few weeks, posting under his real name.
Posting under a false name would violate terms of his parole.

Tony
--
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
   Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

I don't do anything wrong.

I reccomend SQL Server-- where it would fit best.

I choose to reccomend SQL Server; because it is the optimal engine for
using Microsoft Access.

-Aaron

 

[Tony Toews [MVP]]

It's not parole you moron

Ah, probation then?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/