Hi Syed
The attached is a basic example of how you should structure your tables for your Payroll Process.
It is not yet complete but it will give you an idea.
When you open the database it will open "frmEmployees"
You select the required Employee.
Then select the Year and Month
Then in the Tab Control below you will have the following information:-
Transfer Details
Salary Indormation
Monthly Allowances
Monthly Deductions
Absenses
The Payroll Details will update with the information you enter into the above tabs.
If you want any further help on this then I would recommend that you install Skype and chat with me as there is a lot of process's to explain.
Regards
Mike