Create Linked Table based on Select Field?

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?


You can just convert the field to a Link to Another Record type in the Customize Field Type dialogue box and it’ll do that for you.


Thansk, that did exactly what I needed.

Worth a pop up when importing a table from CSV as it is not obvious that will happen when an imported field is converted. Really clever.