• You could combine the EMPLOYEE and TITLE tables in the Data Source View with a Named Query and handle the null values there with something like

    SELECT EMPLOYEE.emp_id,

    ISNULL(EMPLOYEE.title_id,-1) AS title_id,

    ISNULL(TITLE.title_name,'Unknown') AS title_name

    FROM EMPLOYEE

    LEFT OUTER JOIN

    TITLE

    ON EMPLOYEE.title_id = TITLE.title_id