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

Yes I still have problems.

I have the following data in my plant table:
idplant     name                  latin_name
1                 hops                   humulus lupus
2                lady’s slipper    Cypripeduim reginae

The autocomplete list for the name field appears the moment you type the first letter and if you select hops it sets 1 as value for plant_idplant in the research table perfectly.  The problem comes on the second test.  If you select lady’s slipper (idplant 2) it sets  1 as the plant_idplant value and automatically inserts hops instead into name in my research table.  When I had the code for autocomplete on latin_name it does the same thing. I was not sure if the two autocompletes pointing to the same value caused the issue so I removed that line and the problem remains.

I thought perhaps I needed code to clear the selection and get rid of the first value. Should I post my entire grid.php for you?

Stephanie