Aug 04, 2019 07:14 AM
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?
Aug 04, 2019 09:48 AM
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.
Aug 04, 2019 10:31 AM
Thansk, that did exactly what I needed.
Nov 07, 2019 03:10 AM
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.