Thanks, I changed the error in the latin_name autocomplete. Status is now that it works to set the plant_idplant for the name I tested in the “name” field. However, the next test, for a different plant set the value for the first plant. Latin_name field searches also return the same value regardless. I removed the latin_name autocomplete entirely and the only autocomplete line is
$grid->setAutocomplete(“name”,”#plant_idplant”,”SELECT b.idplant, b.name, a.plant_idplant FROM research a, plant b WHERE b.name LIKE ? ORDER BY b.name”,null,true,true);
Do I need to something to refresh the add data after submit?
Thank you so much for assistance.
Stephanie
