linking problem between database table and excel sheet data
i have a sales header and sales detail tables. also a target sales table for salesman in excel. I am supposed to compare actual sales done by salesmen with respect to target from excel. the key to be used is a composite key with the combination of month, brand and salesman number. after linking the tables, i am getting details of salesman which are common in both target and actual. but not the details of target alone. ie; if a salesman hasn't done any sales as per planned for any brand, that value is not shown.