SELECT distinct ID,company,bhal,blah,blah,ID2 from table1 as t1 INNER JOIN table2 as t2 on t1.ID=t2.ID

remember ID2 is from 2nd table and its foreign key in table1.
use the above code in select_command.

Hope It Helps!!

Thanks Varun for your continuous help.
@Davy, i am also sending you sample.

Another option is to select id field in sql (invheader.client_id) with JOIN of reference table (INNER JOIN clients)

$g->select_command = "SELECT id, invdate, invheader.client_id, amount, note FROM invheader
INNER JOIN clients on clients.client_id = invheader.client_id
";

And few changes in column definition.

$col = array();
$col["title"] = "Client";
$col["name"] = "client_id";

# this is required as we need to search in name field, not id
$col["dbname"] = "clients.name";
…
$col["edittype"] = "select"; // render as select

# fetch data from database, with alias k for key, v for value
$str = $g->get_dropdown_values("select distinct client_id as k, name as v from clients");
$col["editoptions"] = array("value"=>$str);

# and set formatter, so that value is shown on grid instead of id
$col["formatter"] = "select"; // display label, not value

$cols[] = $col;

Thanks all,

I received the example and I put the code in the system.
I now indeed see the real value in the grid plus I have it as a dropdown field in my edit form…

But, for a strange reason, from the moment I added this code, when I try to CHANGE a row in the form, the button "Save" does not do anything anymore.
Also, the trashbin (delete) button does not work anymore.

There's no error message… Just return to the grid and nothing changed…

Any help please ?

Greetings,

Davy

Most likely, the edit/delete are not working due to missing PK column (as discussed in other ticket).
It will be resolved once you add PK column.

Abu,

it is solved now… I missed indeed the ID field in my selection formula…

1000 Times thanks

Greetings,

Davy