G
Guest
Hi I am creating a membership database and I would like to have the salary
field autofill with the appropriate wage based on Todays Date -[SenorityDate]
(years of service) referenced also by a field [JobClassification]. In other
words if you were a Data Entry Clerk and you have 3 years senority it would
autofill the wage of a 3 year Data Entry Clerk in the appropriate field.
There are currently 1,2,3,and 4 years for steps. If the employee has 25 years
experience they would still be classed under the 4 year step. Any help would
be appreciated.
field autofill with the appropriate wage based on Todays Date -[SenorityDate]
(years of service) referenced also by a field [JobClassification]. In other
words if you were a Data Entry Clerk and you have 3 years senority it would
autofill the wage of a 3 year Data Entry Clerk in the appropriate field.
There are currently 1,2,3,and 4 years for steps. If the employee has 25 years
experience they would still be classed under the 4 year step. Any help would
be appreciated.