"The dreaded lookup field"

  • Thread starter Thread starter Sue
  • Start date Start date
A misunderstanding, I think. Combo boxes are very good and useful and are
not to be banned. Plus they greatly facilitate the elimination of people
entering bad data.

The "lookup" field issue relates to the property that you can set for a
field in the table itself. Don't do that! Leads to problem when you look at
data that it appears to be the lookup value but instead is the real value;
people forget that and wonder why their queries don't work when they try to
find records where that field's value is the looked-up value and not the
real value.
 
Thanks for clarifying.


Ken Snell (MVP) said:
A misunderstanding, I think. Combo boxes are very good and useful and are
not to be banned. Plus they greatly facilitate the elimination of people
entering bad data.

The "lookup" field issue relates to the property that you can set for a
field in the table itself. Don't do that! Leads to problem when you look
at data that it appears to be the lookup value but instead is the real
value; people forget that and wonder why their queries don't work when
they try to find records where that field's value is the looked-up value
and not the real value.
Click to expand...
 
A misunderstanding, I think. Combo boxes are very good and useful and are
not to be banned. Plus they greatly facilitate the elimination of people
entering bad data.
Click to expand...

Well... they don't eliminate the *people*. You have to call the HR department
(or Cousin Luigi) to do that!

<g, d & r>

John W. Vinson [MVP]
 
John W. Vinson said:
Well... they don't eliminate the *people*. You have to call the HR
department
(or Cousin Luigi) to do that!
Click to expand...

Yep, you're right... a bit of "wishful thinking" crept into my reply.....
 
hmm, do you think MS might add that option to the next version of Access?
i'd buy it in a heartbeat! <bg>
 
tina said:
hmm, do you think MS might add that option to the next version of Access?
i'd buy it in a heartbeat! <bg>
Click to expand...

I don't think it's on the "top 100" list right now..... < s >
 
in message:
hmm, do you think MS might add that option to the next version of Access?
i'd buy it in a heartbeat! <bg>
Click to expand...

It's in the specs at the moment.....



I'm kidding, just kidding!!
:-)

--
Jeff Conrad - Access Junkie - MVP Alumni
Software Development Engineer in Test
XAS Services
Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
 
I don't think it's on the "top 100" list right now..... < s >
Click to expand...

I think it's been on request since before there was a Microsoft... remember
the XOI instruction? Execute Operator Immediate...

John W. Vinson [MVP]
 
tina said:
hmm, do you think MS might add that option to the next version of Access?
i'd buy it in a heartbeat! <bg>
Click to expand...

They had it in Alpha testing but it eliminated the entire team that was
doing the testing.
Now it's tough for MS to find people willing to work on it any further.

Tom Lake
 
ROFL!!

Tom Lake said:
They had it in Alpha testing but it eliminated the entire team that was
doing the testing.
Now it's tough for MS to find people willing to work on it any further.

Tom Lake
Click to expand...
 
I DISAGREE!

Lookup fields ROCK

if you want to get plain text then you should use Query Analyzer or SQL
Server Management Studio

ADP uber alles
 
Back
Top