Hello I tried to search on this but couldn't find anything related.
Basically I have a list of names that has a lookup column that looks back into itself (not a different list) for the title column. This creates a lookup field that gives me a full list of all names contained in the list.
When I attempt to display that lookup field in a repeating table, it gives me numbers not text. When I researched this issue it says that InfoPath is returning the id of the lookup and not the value and that you need to use a calculated column to return the value however I can't seem to get it to work and the examples given were for lookups in different lists not an internal lookup.
Any idea how I can display the value of the lookup?