[mso] Re: LOOKUP
- From: "Dian Chapman" <dian@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 9 May 2002 15:01:00 -0500
I believe you have to add ORDER BY at the end of the look up field and
enter the sort [table].[field] order you want?
Dian Chapman
Technical Consultant,
Microsoft MVP & TechTrax Editor
Tutorial web site: http://www.mousetrax.com
TechTrax Ezine: http://www.mousetrax.com/techtrax/
Word MVP support site: http://www.mvps.org/word
Microsoft support groups: http://support.microsoft.com
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Charles Ippolito
Sent: Thursday, May 09, 2002 1:58 PM
To: MSO
Subject: [mso] LOOKUP
One of my tables contains a field, we'll call it field A. When entering
data on field A, I want to do a LOOKUP to ensure that the only data that
can be entered is what is in another table. So I use the LOOKUP wizard,
and create a LOOKUP using 3 fields from another table. When entering the
data, it shows the 3 columns from the lookup table, but when I select
one of the choices, it returns the value of the first field. I want it
to return the value of the second field. I know I can just change the
order, but I want it alphabetized by the first column, but the second
column to be the return field.
Any help is greatly appreciated!
---Charles
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to
mso@xxxxxxxxxxxxx or to it's earlier version,
MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with a subject line that says "unsubscribe"
(without the quotes). Do not put unsubscribe IN CAPS. Screaming
doesn't get you out any faster and the caps prevent the function from
working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
*************************************************************
PLEASE READ!!!!
You are receiving this mail because you either subscribed to mso@xxxxxxxxxxxxx
or to it's earlier version, MicrosoftOffice@xxxxxxxxxxxxxxxx
To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with
a subject line that says "unsubscribe" (without the quotes). Do not put
unsubscribe IN CAPS. Screaming doesn't get you out any faster and the caps
prevent the function from working.
To change your email settings to digest or vacation (no mail), visit the
group's homepage for full instructions.
//www.freelists.org/webpage/mso
*************************************************************
Other related posts:
