Dropdown store ID and SHOW text

This topic is locked

Dropdown store ID and SHOW text	2/24/2004 8:53:32 AM
ASPRunnerPro General questions
L Loic author Hi, When I build a drop down list with ASP runner interface, I usually use an existing table that contains the OptionID and the Optiontext. example : 1 : BMW 2 : Mercedes 3 : Renault The information stored is the table is the OptionID and that is what I want. But how can I display in the list and Edit page the Optiontext instead of the OptionID. To clarify, If I add a record, and select Mercedes, what I see in the list page, or when I edit the record is 2. Thanks for your help.


	Sergey Kornilov admin 2/25/2004
	Loic, you need to modify default SQL query for the list page like this: select ..., Make.Name as MakeName from TableName inner join Make on TableName.OptionID = Make.MakeID After that you can display MakeName on the list page. If you have problems writing this SQL query manually you can use query designer in MS Access and copy SQL query text to ASPRunner after that.