Hi,
I have a dynamic dropdown on form A to pass an ID to form B via the return URL
I have created a text field to pass the id value into and called it DogsID which appears to work fine and displays the expected value.
I now wish to populate a few other fields in form B based on this id.

In the KC_Name fields default value I have inserted this code.

//<code>
$db = JFactory::getDbo();
$db->setQuery("SELECT `KC_Name` FROM `#__dogs_details` WHERE `Dogs_id`='1' ");
return $db->loadResult();
//</code>

This returns the expected value.

How do I replace the "1" with the value passed by the url into the DogsID field
Cheers
Mark

I have the same question is it possible to post the solution?
Thanks in advance.

Hi,
I am no expert but this how I managed to get this to work.

Form A
Dropdown called DogChoice
Default value:
//<code>
// Prepare the empty array
$items = array();
// Prepare the database connection
$user = JFactory::getUser();
$db = JFactory::getDbo();
$userId = $user->get('id');
// Keep this if you'd like a "Please select" option, otherwise comment or remove it
$items[] = "|Please Select[c]";

// Is the user logged in?
if ($userId) {
// Grab the value from the database.
$db->setQuery("SELECT * FROM `#__dogs_details` WHERE `user_id`='".$userId."'");
$results = $db->loadObjectList();
}

// Now, we need to convert the results into a readable RSForm! Pro format.
// The Items field will accept values in this format:
// value-to-be-stored|value-to-be-shown
// Eg. m|M-sized T-shirt
foreach ($results as $result) {
$value = $result->Dogs_id;
$label = $result->KC_Name;
$items[] = $value.'|'.$label;
}

// Multiple values are separated by new lines, so we need to do this now
$items = implode("\n", $items);

// Now we need to return the value to the field
return $items;
//</code>

Return url: http: yoursite.com/index.php?option=com_rsform...ter={DogChoice:value}


Form B

Textbox called myparameter
Default value:
//<code>
if (JRequest::getVar('myparameter') != '')
{
$myparameter_value = JRequest::getVar('myparameter');
return $myparameter_value;
}
else
{
return 'No value';
}
//</code>

Textbox for KC_Name
default value:

//<code>
$myparameter_value = JRequest::getVar('myparameter');

$db = JFactory::getDbo();
$db->setQuery("SELECT `KC_Name` FROM `#__dogs_details` WHERE `Dogs_id`=' $myparameter_value' ");
return $db->loadResult();
//</code>

Hopefully this will set you on the right path.
Cheers
Mark