I have a value stored in one table that i wish to transfer to another form
I have tblEmployees this stores the employee name, wage rate etc.
I have tblHours this is used each week to input employee wages - the empployee id is entered, the hours worked, the week number etc.
i want tblHours to pick up the wage rate from tblEmployees and display in a field in tblHours as per the employee id entered.
Although, it is possible the rate could change therefore i would like this field to be changed if necessary.
therefore my report for the weeks wages would work from the wage rate in tblHours not the wage rate in tblEmployees.
the only reason i want a wage rate to be in tblEmployees is so that each week my end-user doesn't have to input a wage rate there will be a default from tblEmployees. this ensures less mistakes as all employees are on varying wage rates.
hope its clear what i want to do, and if anyone knows how i can do please can they help me because i'm baffled.
many thanks
I have tblEmployees this stores the employee name, wage rate etc.
I have tblHours this is used each week to input employee wages - the empployee id is entered, the hours worked, the week number etc.
i want tblHours to pick up the wage rate from tblEmployees and display in a field in tblHours as per the employee id entered.
Although, it is possible the rate could change therefore i would like this field to be changed if necessary.
therefore my report for the weeks wages would work from the wage rate in tblHours not the wage rate in tblEmployees.
the only reason i want a wage rate to be in tblEmployees is so that each week my end-user doesn't have to input a wage rate there will be a default from tblEmployees. this ensures less mistakes as all employees are on varying wage rates.
hope its clear what i want to do, and if anyone knows how i can do please can they help me because i'm baffled.
many thanks