G
Guest
Hi
I have a table of employee information and a form based on this table for
user to input.
I have a field for staff grade and I want, when this is selected from a drop
down list , another field to be filled with the salary amount for that grade
automatically and to be saved to the table.
i have guessed I need a second table of two columns for grade and salary
rate but I am not sure if code is needed to perform the update or where to
put it. Beginner here so any tips to get this working would be appreciated
Thanks
I have a table of employee information and a form based on this table for
user to input.
I have a field for staff grade and I want, when this is selected from a drop
down list , another field to be filled with the salary amount for that grade
automatically and to be saved to the table.
i have guessed I need a second table of two columns for grade and salary
rate but I am not sure if code is needed to perform the update or where to
put it. Beginner here so any tips to get this working would be appreciated
Thanks