wilded
6/29/2017 - 7:45 AM

Select Values (Not existing in another table)

Select Values (Not existing in another table)

@ Foreign Keys (sales_charges_documents_grid.php):
"charDocChaID"=>array("table"=>"tblCharges", "field_key"=>"chaID", "field_name"=>"CONCAT_WS('', chaID, ' - (Venta ', chaSalID, ')')", "view_type"=>"dropdownlist", "condition"=>"(SELECT COUNT(charDocID) FROM tblChargesDocs WHERE charDocChaID = chaID) < 1", "order_by_field"=>"chaID", "order_type"=>"DESC", "on_js_event"=>""),