populate fields in an existing record with look up data
I have a nifty database for my faculty that I use to build clinic schedules, track vacation time, and set up the call schedule. However, I populate all the fields using scripts for each day of the week and AM versus PM sessions. I have set up a table with days of the week and the fields all populated with the plan to simply link the day of week table to the main table and look up each field value. However, I already have the calendar populated through 2020 and simply want to be able to update the fields with new lookup data as I move from one day to the next.
Example: We are losing a partner and I have to adjust the schedule. Rather than rewrite or edit 10 scripts I want to be able to simply update the main week day schedule table then advance forward in the main table and have the fields update.
How do I do that. A bit of a newbie here and quite the tinkerer so all help is appreciated.