2. PHPRunner General questions
  3. [SOLVED]  lookup value on add page differs from list?
This topic is locked
[SOLVED]

 lookup value on add page differs from list?

 		5/30/2009 12:56:34 AM
PHPRunner General questions
A
 amuro author

Hi, Jane
please see the shots on add and list page



Here is the project structure.

The table is cdrhmas, customer's order.

The 1st column, named cusno, refers to cdrcus table which is customer's profile.

the other column, named shptrseq, refers to cdrscus table which is customer's shipping profile, and is dependent on first column.
The selection is correct on add page, but why all values are the same on list page no matter the first column I chose.
Thank you!
A
 		amuro author 5/30/2009

Hi, Jane
I find list page use DisplayLookupWizard function to show value up.
It seems not to use dependent column, which is cusno in my case.
For example, the $LookupSQL is "SELECE address1 FROM cdrscus WHERE trseq=$value".

I thought it should be "SELECT address1 FROM cdrscus WHERE trseq=$value AND cusno='XXX'", XXX is dependent value.
I hope you could understand what I say <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=41514&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Please advise me, thank you.
J
 		Jane 6/1/2009

Hi,
please download and install latest PHPRunner build 2135.

Then open and rebuild your project.
If it doesn't help 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.