mike60smart
Registered User.
- Local time
- Today, 13:09
- Joined
- Aug 6, 2017
- Messages
- 1,911
Thanks for your quick reply. I am sure you study more and take time thanks again for that.I have looked and you have set the properties in the table for a lot of your fields to be Lookups.
In your Employee table for example the DepartmentID has the following properties set:-
Hi
OK so you do not have tblEmployee currently linked to LtblDepartments
You should link these 2 tables on DepartmentID and then in the underlying tblEmployee the property of DepartmentID should be as follows:-
Also in tblEmployee you should not have a field for Gross Salary.
You should have a separate table to record the Employees Salaries. Over time they will get increases in salary and you should record a DateFrom and DateTo for each Salary Increase. This way you will maintain a History of Employees Salaries.
this is updated dbCan you upload your complete database?
Hi
OK so 1 Employee has a Basic Salary.
You then want to be able to :-
1. Add any Monthly Allowances
2. Deduct any Monthly Absence Days
3. Deduct any Monthly Deductions
You need to stop and go back to basic table design.
What Rate of Pay is Overtime?
Also I need your complete database to give you an example. Each time you upload a copy of the database there are tables missing?
HeyHi
As I said I need you to upload the complete copy of your database as I am not willing to recreate / create the tables that are missing.
Thanks for another reply. I dont want to others example, Leave it all,Sorry there are too many tables to recreate to give you an example of how to achieve what you need.
Luck with your project and I will leave someone else to answer any more questions.
Hey,i am afraid i cannot if you want the Whole program/package.
it will take lot of time and code.
show the Excel file and someone, perhaps will convert it to Access.
Hey thanks for reply.In your tblPayroll you have a field named "WorkedDays"
What value do you type in this Field? Is it the Total Number of Days worked in a specific Month?