Lookup Column Return Column other than the Primary Name Column

[srosenbloom]

Hey All,

I've got a lookup column in a table, that is looking to another table where the NON-Primary Name Column, which is a multiline text column, is the one a want to show. Is this possible, or can it ONLY return the Primary Name Column. If that's the case, can the Primary Name Column be set as a multiline text column?

Thanks,

Scott

[cchannon · Accepted solution]

Primary column cannot be multiline text and the primary column is always the display name of the lookup. What you can do is change the View that the Lookup uses, so when users are searching for a match, it displays whatever other column(s) you want them to search on.

[srosenbloom]

Ahh! Perfect! Thanks!