I am being asked to replace a text field column ("Category") with a dropdown field that gets its values from another list. I was thinking of using a List Lookup field to do this.
Newly created records (e.g. list items created after the change) have no issue. However, if I attempt to view older records, I encounter an issue: the data stored in the "Category" column does not load correctly in the List Lookup dropdown. The value (ex. "Emergency") exists in the list being referenced by the List Lookup field, but it does not appear.
Is there something I can do to force the List Lookup field to display the value of its "Text Connected to" column?