Possible to imitate the Multi-field dropdown server behaviour in ADDT from Interakt using Data Bridge V2?

Wondering if it is possible to imitate the Multi-field dropdown server behaviour in ADDT from Interakt using Data Bridge V2? I have a form with a dynamic select and need 2 textfields populated in same form with values from the select db. If possible can you please provide an example? Thank you for your time.

Check out this tutorial:
http://www.webassist.com/tutorials/Dynamic-Dropdowns-with-Data-Bridge-2-0

I think that is what you are looking for.

I had looked at that but don't actually need a dependant drop down.
I have a dropdown on a form that feeds off a table that has
id, age, age_category and price fields ,
what I require to happen is when the person picks the age from the drop down two other form textfields are populated one by the age_category value and one by the price value.
I found this article in the forum http://www.webassist.com/forums/posts.php?id=39171 which seems to be similar to what I require but can't figure out how to filter the second recordset properly to make it work.
Thanks
Randy

You could still use that tutorial... but it might be overkill.

The easier solution (although it requires some hand coding) would be to put the age_category and price values into the select list <option> tag with attributes like:

<option age="" price="" value="">text</option>

and then populate the age, price, value, and text from your recordset. Then add an onchange event to the select list that calls a function. That function can check the the current selection in the list and populate the text fields based on the attributes you added.

I have setup the <option> tag as follows
<option age="<?php echo($Recordset1->getColumnVal("age")); ?>" price="<?php echo($Recordset1->getColumnVal("prices")); ?>" value="<?php echo($Recordset1->getColumnVal("cat")); ?>"><?php echo($Recordset1->getColumnVal("age")); ?></option>
This this correct?

Sorry, unfortunately I am not smart enough to setup a function, are you able to assist?
Thank you
Randy

Attach your page to a reply and I can help.

I have attached . Please note I have some PVII components used on there in case you are wondering and they cause issues

So I think you could do:

<select name="age" class="TEXT90" id="age" onchange="ageUpdate()">

Then somewhere you define the ageUpdate function like:

function ageUpdate() {
  var ageList = document.getElementById("age");
  var ageSelected = ageList.options[ageList.selectedIndex];
  document.getElementById("cat").value = ageSelected.value;
  document.getElementById("prices").value = ageSelected.getAttribute("price");
}

Thank you Ray.
I used a variation of that and got it to work,
Thank you for you time!