I have a field with multiple select options in a table.

When I click the Approve field (checkbox), I want the data (the selected options) to be copied to a namesake field in another table.

Currently, I have the namesake field in the 2nd table as a single line text and so it works. However, in the 2nd table, it does not appear as multi option data. The challenge is that I am running a marketplace app and I want to create a filter-based search option and single line data doesn’t work.

There is a video posted in a previous question but that doesn’t solve my problem. I also tried to link the 2nd table’s field to the first but no luck.

Would this be possible in the first place?

As always, many many thanks for the tips.