
$s  = "
        SELECT * 
        FROM zzzzsys_tab 
        JOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id
        WHERE zzzzsys_tab_id = '#LOOKUP_RECORD_ID#'
        
        ";

$t  = nuRunQuery($s);
$r  = db_fetch_object($t);

nuSetFormValue('sob_all_zzzzsys_form_id', $r->syt_zzzzsys_form_id);
nuSetFormValue('sob_all_table', $r->sfo_table);
