Originally Posted by
saruafra
Dear All
I Have 2 forms based on 2 Tables Emp_Mast & Sal_Mast. Emp_mast have records of Emp_Id, Emp_Name, Basic_Salary etc..... and Sal_Mast have record of Emp_Id, Emp_Name, Basic_Salary, Ot_Hrs, Net_Salary etc....
To make Salary Calculations what I need is If I enter Emp_Id in the Sal_Mast form it will display the Emp_Name, Basic_Salary from the emp_Mast table related to the given Emp_Id in the last focus of Emp_Id. and save to Sal_Mast Table.
Please anyone provide me the solution
Thanks