Need a little better description as to what you mean. Is there an ORDER BY field? And, how does this relate to the actual value that is returned? Also, please keep in mind that I am trying to do this is the TABLE, not a FORM... if that changes matters. ---Charlie ----- Original Message ----- From: Dian Chapman To: mso@xxxxxxxxxxxxx Sent: Thursday, May 09, 2002 4:01 PM Subject: [mso] Re: LOOKUP 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 ************************************************************* ************************************************************* 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 *************************************************************