Dear All.
I am Ismail , new in MS access,
i have made a database for my company that include emplyee Information EmployeeName, ID number ,Salary basic , housing, telephone , in TBEmployee and etc,..
my manager now need to add Payroll in same database. so i have made a table for payroll called TBpayroll with Name, ID number ,Salary basic , housing, telephone, OT, OTTravel, Leavepay, Airfair .
I have made a Form FrmSalary that bounded to TBpayroll with all field.
My Question : Can i get vallues in FrmSalary text field Salary basic , housing, telephone from table TBEmployee by selecting EmployeeName combo box.
Please give me a solution,