2. ASPRunnerPro General questions
  3. Lookup Wizard Problem
This topic is locked

Lookup Wizard Problem

 		2/18/2005 4:40:48 AM
ASPRunnerPro General questions
BeachyLife author

Can anyone help me figure out why my Lookup Wizard in ASPRunner Pro is not working. Here's what I'm trying to do: I have a table (Schools) of 900+ School Names and their associated School ID. I have a table (Students) and want to store the School ID from the Schools Table in the Student's record by using the Lookup Wizard. On the formatting page I specify the Lookup Wizard with Link Field of School Id and Display Field of School Name. When I select the School Name from the dropdown list it correctly inserts the School ID in the database, but the School Name shows up in the List, View and Edit pages instead of showing the School ID. I need to see the School ID not School Name so I can export the ID not name. I've tries every which way to get this to work but no luck, so I'm stuck with a manual lookup of the School ID from a printout and then entering it myself on the edit screen.
What baffles me most is that I did the exact same thing back in Sept with a different database and tables and the Lookup Wizard works just fine. I select a name from the list and it displays the ID as well as inserts it to the database. It was a cinch to set up back then and I thought it would be the same this time, but it's not. I can't figure out what's different, except that maybe ASP Runner Pro is a newer version now and the Lookup Wizard doesn't work like that any more. Anyone else having problems with the Lookup Wizard...or better yet, anyone able to help me get this to work? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1146&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
A
 		avion 2/18/2005

.....On the formatting page I specify the Lookup Wizard with Link Field of School Id and Display Field of School Name .....
put display field also as school id & not school name
BeachyLife author 2/18/2005

No, that doesn't work. Tried it and now the dropdown list contains the 900+ School ID's. I don't know what School Name goes with each School ID. That's what I'm trying to accomplish with the Lookup Wizard. When the I find the School Name in the drop down list and select it, I want the School ID to get inserted to the database record as well as show up on the List, View and Edit pages.
Sergey Kornilov admin 2/21/2005

In ASPRunnerPro 3.1a that you use the same display field appears on list, view, print etc pages. This field also appears on the drop-down list, while link field will be inserted into the database.
It sounds like you need to use ASPRunnerPro 3.1 or below:

http://www.asprunner.com/files/asprunnerpro31.exe
BeachyLife author 2/21/2005

Why did the functionality of the Lookup Wizard change with version 3.1a? It was so nice to have the Link Field show up on the List and View pages. I hesitate to use older versions of ASP Runner Pro because then I'll be afraid that my project will not work correctly when newer versions come out.
Any chance of changing this to work the old way in your next version?
Sergey Kornilov admin 2/22/2005

This won't be changed in future versions of ASPRunner. The whole idea of display field is to hide Link Field which is not human readable in most cases.
I can help you fix your code if you send all your files to support@xlinesoft.com. Also I need to know what pages need to display SchoolID instead of school name.