You are in the wrong forum.

Please post your problem here:

http://www.trirand.net/forum/

This place is for the open source Java Script only jqGrid, while you try the commetial jqGrid PHP component.

Best Regards

Tony

Is anyone supporting jqGrid?  Is the author/team still around? 

I'm not going to pay $300 for something that can't edit data from more than one table and has no support whatsoever... has anyone been able to get this to work?  How did you do it?

• I have downloaded and installed the application from here: jqGrid for PHP 3.8.2.1 http://www.trirand.net/download.aspx
• I have read through and tried both of these methods: Master Detail On Select and Sub Grid (2 nested levels).  I am using these guides: http://www.trirand.net/demophp.aspx and http://www.trirand.net/documen...../index.htm

This is the problem:  I can't seem to get anything to work, because in the first table ("users"), I have a primary key "uid", but in the second table that I also need to be able to edit, "profiles", I do not have that same primary key.  So I have to do a complex SQL select command that uses a third table as an intermediary (the "node" table):

However, if I set up editing in jqGrid, it only can post the updates to the "users" table, since that is the table is chosen for editing in grid.php ($grid->table = 'users';) and that table has the primary key (uid).  Any other changes are NOT saved to the database.

Currently, I have a Master/Detail layout set up, with the Master grid displaying data from the "users" table, and the Detail grid displaying data from the "profiles" table.  However, this ALSO has to rely on a complex SELECT command in "detail.php", and it doesn't work - the detail table is blank unless I remove the last AND statement, in which case it displays all records, not the one that I select in the Master table.

Am I going about this all wrong?  Can I edit two tables from the same grid?  If not, can I do it with a SubGrid or a Master/Detail setup?  Am I required to have the same primary key in both tables to do anything at all?

Please help, I will have to abandon this project and jqGrid in general if no one has any ideas on how to do this.  (You would think this would be easy.)