I'm building a DB for a mentor-ship program and just can't seem to find what I'm looking for. I am looking for a way to auto-assign a mentor to a new addition to the DB - for example: I have a checkbox field that, when checked, will automatically assign the next name from a rotating list of names in the next field. I feel like it might be a macro or formatting formula, but also think I'm overthinking it. I'm new to Access so my skills are still in development, and decided to seek help from the Pros! Currently I just have a dropdown list, but am looking for something that will assist with the rotation aspect so I don't have to keep a separate log of who's up next.
Thank you in advance for any help, guidance, or assistance you might be able to offer!