Hi all
thanks for this great tool.
sorry, I tried to solve my problem reading the other posts but I can’t get this working.

Example:

Mysql DB Table
tbl_local (idtbl_local; Description) values (1,Ombro; 2,Cotovelo; 3,Braco….)
tbl_classf(idtbl_classf; Description; id_local) values (2,’Classificação 102′, 1; 3,’Classificação 6′,1)

relationship: tbl.tbl_classf.id_local<->tbl_local.idtbl_local

I’m using a view to upload the values from database to jqgrid:
CREATE VIEW ortodb.view_classf_local AS select a.idtbl_classf AS ID,a.description AS Description,a.id_local AS id_local,b.idtbl_local AS id_join_local,b.Description AS Local_Description from (ortodb.tbl_classf a left join ortodb.tbl_local b on((a.id_local = b.idtbl_local)))

 

I try to use jqgrid to edit/add the tbl_classf populating the edit form with the select “local” (tbl_local.Description) and update the id_local from tbl_classf

 

I need help to create a select option with all ‘local’ options, but showing the default value selected.
and finally update and add to database.
thanks in advance.

sorry by my bad english.
I’m Portuguese.