2. ASPRunnerPro General questions
  3. Dependant lookup box in advanced serach does not work...
This topic is locked

Dependant lookup box in advanced serach does not work...

 		7/16/2007 12:45:51 PM
ASPRunnerPro General questions
G
 gnabi author

I am using Asprunner build 275. I am trying to understand how dependant drop down boxes works on advanced search page. I am using Cars database provided with asprunner as an example.
It works fine on the design page. But once I build the project and open it up in browser it does not work.
I have two drop downs on the search page.
Make - This works fine. I can see all the makes which are in the database.

Model - This is depandant of make. This does not display any model. No mater what make I select from the Make drop down. But it works fine on the design page during test.
Here is how I have defined Model drop down box.
Table: models

Linked field: model

Display field : model
Checked - this drop down is dependant on.
Category control: Make

Category field: make
Can some one please tell me what I am doing wrong. Thank you very much!.
Sergey Kornilov admin 7/16/2007

Post your app to demo account (last tab in ASPRunnerPro) and send the URL to support@xlinesoft.com.
G
 		gnabi author 7/16/2007

I have uploaded the code. Please take a look. Thanks, gnabi
http://demo.asprunner.net/nghulam%5Fyahoo%...3/cars_list.asp
Sergey Kornilov admin 7/17/2007

Answered to your personal email
G
 		gnabi author 7/17/2007

correct URL:
[url=http://demo.asprunner.net/nghulam%5Fyahoo%5Fcom/cars3/cars_list.asp]
A
 		akira_nagasaki 12/23/2008

i also got the same problem, but my problem is. some value is appeared but it's all working in test design
example :
Field A :

A

B

C

D

E

F
Field B

1

2

3

4

5

6
in test ( design) Field B all appear but when i build the asp page.. some of the field B is missing let say no 3 5 6 is missing.
please help <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=36210&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
J
 		Jane 12/23/2008

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
A
 		akira_nagasaki 12/25/2008

tq jane,
i solved the problem.
Field A and Field B from TABLE Z lookup to another field in TABLE Y
solution : Field A and Field B character and string exactly same with field in TABLE Y and problem solved <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=36287&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />