Custom field updated from lookup table

Not sure if this option is available yet, but in my condo, the pool code changes monthly. It would be nice to have a way for OR update a custom field depending on the month.