Q: Can I create a column that will display a 2nd column of data using a lookup column as the key to another list?

Nov 15, 2010 at 11:15 PM

I'm not sure if the Filtered Lookup Field can do this, so please let me know if it cannot.  Here's what I'm trying to do:

  • I have List A, with two single line text columns "Website Name (Title)" and "URL".
  • In List B, I have added a single column that is a standard lookup against List A returning Website Name.
  • When I create a new item in List B, I select a Website Name from the dropdown.
  • When I view the list, I want to see the text of WebSite Name in one column, and the associated URL (from list A) displayed as another column.