Altering Web Table Fields

[thegooser]

Is it possibale to alter a property on a field in a web table after it is set up?

I want to change a normal text field to a drop down. I can see how I can do it with a new field, but I need to edit the existing field.

Any ideas?

 

[Banana]

You can alter some of properties but changing a filed from text to lookup is not one of them. You'd need to add a new field, delete the old field.

If you want to keep the original data when you alter, do the following:

1) Add anew field with desired properties and name it with a temporary placehoolder
2) Select the original column (on its heading, not the cells) so the whole column is highlighted.
3) Type Ctrl-C to copy the contents.
4) Select the new original and press Ctrl-V to paste it into.
5) Say yes to the prompt that appears about updating records
6) Delete the original column
7) Rename the new column to same name as the original column