I have created two tables containing the SALARY and DEDUCTION . In the SALARY table i created 2 fieldname call 'Montly Salary' and 'Salary Deduction'. For the DEDUCTION table i had 2 fieldname call 'Salary Range' and 'Sum of Deduction'.
My problem is, i want fieldname 'salary deduction' automaticly do a Vlookup to DEDUCTION table. I try to create but MS Access not recognise the VLookup funtion.