I created a list with a choice column. Let's call this list List A. I modified the form through InfoPath and set it up so that the choice options are connected to another SharePoint list (List B). Changing list items in List B updated the choice column options in List A.
Now the problem is that as the choice column options are updated via List B, previously checked off options in List A that are not in List B anymore are still visible. I'd like them to disappear as List B is changed as that data in List A is irrelevant at that point. I am mainly afraid that I could run into size limit issues with dozens of checked off choice items and growing without an easy way to purge the data.
Does anyone have any suggestions?