Possible to convert current text field into lookup field?

Question

Is it possible to convert a current text field into a lookup field?

I have a current text field in a table that is an employee name (text input field). I would rather that field actually be a lookup field. In a simple use case, I could simply add the lookup field for the name, and then delete the current field. My problem is the current field itself is looked up numerous times on other tables. I would like to avoid going down the rabbit hole of finding all the places I need to pass a new lookup field, change reports etc. Would be much cleaner if I could change the existing field to a lookup. Is it possible?

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

np,sort of.bring down the lookup field and call it [xyz (lookup)]Change the current text data entry field to a formula[xyz (lookup)]------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community