2. PHPRunner General questions
  3. Display Related information
This topic is locked

Display Related information

 		10/15/2009 14:46:56
PHPRunner General questions
K
 kplunkert author

I apologize in advance, this has probably been answer, I just could not find it.
I am using PHPRunner 5.1

I have two tables, orders and customers that are related through the customer ID.

The user selects a customer ID from a listbox then I want to display the related Name, city and state for that customer.
How do I accomplish this.
Thanks in advance.
KJ Plunkert
woodey2002 10/15/2009

http://www.xlinesoft.com/tutorials/dependentdropdowns.htm
This may help.
Regards
James

PhpRunners No 1 Irish Fan.
K
 		kplunkert author 10/16/2009

Not exactly what I was looking for. This is not a cascading list box situation. Just display static information from a table - pick a name display that name's city and state.



http://www.xlinesoft.com/tutorials/dependentdropdowns.htm
This may help.
Regards
James

PhpRunners No 1 Irish Fan.
J
 		Jane 10/16/2009

Hi,
if you don't want dropdowns choose Lookup wizard->Edit box with ajax popup option.
K
 		kplunkert author 10/16/2009

That works pretty close to what I was wanted.
Is there any way to make that read only?
Karl Plunkert
J
 		Jane 10/19/2009

Hi,
use JavaScript to st up this field as disabled.

Here is a sample:

<script>

document.forms.editform.value_CustomerID.onchange = function()

{

document.forms.editform.display_value_FieldName1.disabled = true;

document.forms.editform.display_value_FieldName2.disabled = true;

}

</script>



To add JavaScirpt code proceed to the Visual Editor tab and switch to HTML mode.