Create Linked Table based on Select Field?

[Larry_Heidkamp]

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

[Kamille_Parks]

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.

[Larry_Heidkamp]

Thansk, that did exactly what I needed.

[Brian_Orpin]

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.