MichaelBate
06-25-2008, 03:57 AM
A posting in the FAQ says that developers can set hours worked by poking into an MS Access database. I have a couple of questions:
1. The FAQ says that hours should be inserted into the employee record (dbMainEmployee) not a transaction record (dbTransEmployee). Since hours may vary from week to week, I would have thought that I should create a new transaction record to contain the hours.
2. Once hours have been posted (either in dbMainEmployee or dbTransEmployee) is there any way to get PayWindow to calculate the net pay, applying taxes and the other deductions?
I have a client who wants to use his existing method for entering data. I am a professional software developer and have worked with databases in the past (but not with Access).
1. The FAQ says that hours should be inserted into the employee record (dbMainEmployee) not a transaction record (dbTransEmployee). Since hours may vary from week to week, I would have thought that I should create a new transaction record to contain the hours.
2. Once hours have been posted (either in dbMainEmployee or dbTransEmployee) is there any way to get PayWindow to calculate the net pay, applying taxes and the other deductions?
I have a client who wants to use his existing method for entering data. I am a professional software developer and have worked with databases in the past (but not with Access).