This topic is locked

List 2 fields in drop down list

3/24/2005 5:02:34 PM
ASPRunnerPro General questions
D
ducmis author

I want to be able to have 2 fields to appear in my drop down list. I have a WWID field, and a Name field. I want the user to see both the WWID and Name in the drop down list, linked by the WWID. Since there are over 200,000 people in my company, Names are common, so it can be distinguish by the WWID. The user may or may not know the WWID when entering the data. That's why I want both field to show. How can i do this? Can someone help?

Sergey Kornilov admin 3/25/2005

Hi,
you need to modify SQL query in Lookup wizard tab:
SELECT [Name], cust(WWID as varchar(20))+' '+[Name]

FROM [Employees]

ORDER BY [Name]

D
ducmis author 3/29/2005

Thank You !!! it works