Need help with script -- update multiselect field options based on another table

[yyossefy]

I have a base with two tables: the first is a basic table with a list of records that change somewhat frequently. The second table has a multi-select field whose options should be whatever records are in the first table-view.

I'd love to have a script that goes to the multi-select field in table 2, deletes all of the options in it currently, and then replaces the options with the records in table 1. The idea would be to put that script in an automation that runs once a day at midnight, ensuring the options in the multi-select field are always up-to-date.

Any idea how to write this script?

[ScottWorld]

The best way to do this would be to create a linked record field instead of a multi-select field.

[yyossefy]

We tried using a linked record field but unfortunately it doesn't work for a few other reasons. (For example, it confused many of our users in the way it showed up on forms)