2. ASPRunnerPro General questions
  3. Drop Down Problems
This topic is locked

Drop Down Problems

 		8/12/2006 1:26:50 PM
ASPRunnerPro General questions
W
 waynem author

I am trying to set up a couple of drop downs using the Lookup Wizard.
Although I have Unique Values checked off, I am getting multiples from my table. What am I doing wrong? The values I am looking up are in the same table as the records I am displaying.
I converted this table to SQL from Access. If I edit a record, the drop down fields are empty. If a save, they save empty. If I manually fill in the correct value and click save, they stay saved, even when I return to that record. But all the other records remain blank. Any ideas why this is happening? I don't want to lose the values of these fields accidently when editing other fields in the record and saving. I also don't want to manually fill in the drop down fields for every record.
Is there a way to take one field, called Category, and have it display as a drop down in the Search menu, so people would know what the available options are?
Any advice would be greatly appreciated.
Thanks!
Sergey Kornilov admin 8/14/2006

Probably values in this table are not exactly the same. Make sure you don't have any extra spaces before or after field values.
If this doesn't help send your files to support@xlinesoft.com for investigation.
If you make a dropdown box it appears this way on all Add/Edit/Search pages.
W
 		waynem author 8/14/2006

Probably values in this table are not exactly the same. Make sure you don't have any extra spaces before or after field values.

If this doesn't help send your files to support@xlinesoft.com for investigation.
If you make a dropdown box it appears this way on all Add/Edit/Search pages.


Thanks, I'm not sure I probably had some issues with the database side.
Can you answer this question:
Is there a way to take one field, called Category, and have it display as a drop down in the Search menu, so people would know what the available options are?
It would be nice to have search fields populated with database table data when the list is not that long.