I am trying to follow the demo @ http://trirand.com/blog/jqgrid/jqgrid.html Advanced > Master Detail which is basically has a Main grid and when you click on a row on the Master Grid a subgrid is populated with data about that id.

The data I have in my primary grid is somewhat of a log of computers, and these computers repeat themselves numerous times. I have other tables in my db that share other specific computer information that I'd like to display on the subgrid but the problem I am having is that the example demonstrates how to do this with the id record, and as you may know the id records needs to be unique. Unfortunately the unique id of the table that populates the primary grid is unique to that table. How can I go about populating the subgrid with data in this scenario?

My thoughts are:

1. Using a js function onSelectRow to get a specific column in ColModel and set that as the id for the sub grid url.

2. Somehow approach this at the database level and somehow perform a join on two tables using unique data on table 1 to join with table 2. I don't know how this could be done though.