I created a table with a Single Select field. After using the table for a while I found that I should have created a Link to Another Record table instead.
Is there a way to add the options in the Single Select to a new table and automatically link the records in the existing records to it?
Thanks