I have a select box auto-populated based on a table. I would like some assistance in auto-populating two secondary text fields based on the first selection.

In my table I have equipment 'Name', 'Serial', 'Location', etc. The first select box is auto-populated with the equipment's 'Name'. What I want is the next fields to then populate with that piece of equipment's location, serial, etc.

Any help with this would be appreciated!!

A similar example is posted here:

http://demo.rsjoomla.com/dynamic-drop-down-change-form-example

I am new to Java and Joomla so please bare with me. I am a C# SQL programmer so I am quite sure it is only syntax or I have missed a method on the textbox object

I have looked at the sample and have modified it to use my array. but I acually don't need another drop dowm list, only a text box. I thought using

thechild.value = parent_array[parent_value][0];

where theChild is a textbox.
But no joy, the text box stays blank. Is there a refresh or something else I need to do?

Thanks

Figured it out, forgot the quotes on the onchange

Could you post your solution so others may benefit?

Thank you

Hi Richard

any chance you could post your solution please, as i am experiencing same cenario in needing to auto populate text field from a dropdown.

In order to provide further assistance please provide a more accurate explanation of your scenario. You want to populate a dropdown based on a table? Or the value selected in the dropdown to be copied in a textbox?

An example on how to populate a list based on a table can be found here:
http://www.rsjoomla.com/support/documentation/view-article/94-auto-populate-a-list-from-a-table.html

An example on how you can copy the value of a field through the use of Javascript can be found here:
http://www.rsjoomla.com/support/documentation/view-article/496-preview-data-before-submit.html

You can even take a look at the "Conditional Fields" functionality of RSForm!Pro which will allow you to show or hide a field based on the user's selections.
http://www.rsjoomla.com/support/documentation/view-article/749-conditional-fields.html