I set a column as lookup:

$col = array();
$col["name"] = "idCustomer";
$col["edittype"] = "lookup";
$col["editoptions"] = array("table"=>"Customers", "id"=>"id", "label"=>"customer");
$cols[] = $col;

My table’s column, however, allows the value to be null, and actually I need the user to set it. This is useful for example if the field is not mandatory. If I don’t have a customer, no id should be entered.

The rendered select contains the customer names only.

I tried:

• with cellEdit using “canc/del” but on reload the last value is still there
• with inline editing no way to remove the value
• with edit dialog is the same

I would like either a null entry in the select or a way to set it null (i.e. del when editing inline or a checkbox when in dialog).

Is it possible or is there a different way to achieve my goal?