if ($item == 'table_id') {
            // get data from the database, ignoring any tables which have no entries on DICT_COLUMN
            $this->sql_select     = 'dict_table.table_id, table_desc, count(dict_column.table_id) as column_count';
            $this->sql_orderby    = 'dict_table.table_id';
            $this->sql_ordery_seq = 'asc';
            $this->sql_from       = 'dict_table '
                                  . 'LEFT JOIN dict_column ON (dict_table.database_id=dict_column.database_id AND dict_table.table_id=dict_column.table_id) ';
            $this->sql_having     = 'column_count > 0';
            $this->sql_groupby    = 'dict_table.table_id, table_desc,AJW_RAD_GET_REL_TABLE_COUNT(DICT_TABLE.DATABASE_ID, DICT_TABLE.TABLE_ID) ';
            $data = $this->getData($where);

            // convert each row into 'id=id' in the output array
            foreach ($data as $row => $rowdata) {
                $rowvalues = array_values($rowdata);
                $array[$rowvalues[0]] = $rowvalues[0];
            } // foreach
            return $array;
        } // if

CREATE OR REPLACE FUNCTION AJW_RAD_GET_REL_TABLE_COUNT(IN_DB VARCHAR2, IN_TAB VARCHAR2) RETURN NUMBER
IS

V_RETURN NUMBER;

BEGIN

BEGIN

SELECT COUNT(*)
INTO V_RETURN
FROM DICT_RELATIONSHIP
WHERE
	DATABASE_ID_SNR	=	IN_DB AND
	TABLE_ID_SNR	=	IN_TAB;

EXCEPTION
WHEN OTHERS
THEN
	RETURN 0;

END;

RETURN V_RETURN;

END;
/