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.

1 Like

Thansk, that did exactly what I needed.