Help with Data entry

Originally Posted by mobaligh

I have two tables, tblEmployees and tblEmployeepayment. tblEmployees has the following fields the data to this table comes from our payroll system

EmployeeID
Name
Paygroup
Employeestatus
Annualsalary

tlbEmployeepayment has the following fields which will be entered by the user.

EmployeeID
PayPerioddt
Paybegdate
Payenddate
Partialpayment
Hours
Annualsalary

I have created query from these two tables. I have one to many releationship between tblEmployees and tblEmployeepayment based on EmployeeID. I need annualsalary in my tblemployeepayment tble because I want to keep track of their salary based on payperiod. For exmple if on 5/15/2007 their salary 50000 and on 5/31/07 their salary 55000 I want keep their salary history for each pay period. The question is that when the users start data entery I want to auto populate the salaryfield for them to reduce data entery errors. Can someone help please.

Originally Posted by JConsulting

my first thought is that you need to add an Index to your tblEmployeepayment table
UniqueID
EmployeeID
PayPerioddt
Paybegdate
Payenddate
Partialpayment
Hours
Annualsalary

How are you set up for data entry? A primary form with a subform?
J

Originally Posted by mobaligh

Yes. I have a primary form witha subform. I do have a uniqueId in tbleployeepayment table forgot to mention it.

Originally Posted by JConsulting

>>The question is that when the users start data entery I want to auto populate the salaryfield for them to reduce data entery errors. Can someone help please.

When you're beginning your data entry...

They open a record to a specific Employee?
Are they entering Hours?

How about on the form's On_Current event you do a look up based on the employee id and assign it as the Salary

me.salary = nz(dlookup("Salary","EmployeeTable","EmployeeID = " & me.EmployeeID))

something like that.
J

Originally Posted by mobaligh

I dont' want to do a calculated field, because I want to store the salary for each pay period. When the user opens the form they enter pay period, begin date and end date and hours. I would like to keep the history for each of the pay period