Is it possible to have a table itself look up a value from another table, and change itself accordingly?

IE) Paybands are a # of 1-20.
Every year at the company, when the users's anniversary hits, the payband should increase.

WorkerInformation is the table holding the current payband of which I want to change("CurrPayband" field), as well as the anniversary date for that worker ("Anniversary" field)