Contents
Can a column be added to a list?
I can add the latter column to a list view, and it does display there correctly, but I cannot find any easy way to add it to the Item content type, or otherwise get it to show up on the OOTB DisplayForm.
When do you create a lookup column in a source list?
When you create a lookup column in a source list, the primary column displays values from the target list column, but you can also specify that additional, secondary columns from the target list also display alongside the primary column and the other source list columns.
In SharePoint Foundation 2010, you can create multiple-column lookups to the same lookup list. For example, suppose that you have two lists, Customers and Pending Orders. You create a relationship between the lists by adding a Customer ID column to the Pending Orders list and point the column at the ID field in the Customers list.
Can a unique column be used in a lookup column?
The following table summarizes what column types can and cannot be used to create unique columns. To create a relationship between two lists, you create a lookup column in the source list that retrieves (or “looks up”) one or more matching values from a target list.
How to add a column to my choice?
Say the choice column that you want to use is called ‘My Choice’, create a calculated column with the formula [My Choice]then this calculated column is available in the “Add columns to show additional fields” options. This will probably also do for a look-up column too.
Why is my column not shown under ” add column to…”?
This was possible in SharePoint 2010 before SP1, but after SP1 it seems to be no longer possible. I can’t see a good reason why, and it is very annoying. There is no way of making additional types of column available in the look up control as far as I know. Share Improve this answer Follow answered Jun 27 ’12 at 9:11
How to create a new column in Excel?
Go the origional list that has the information you’d like to look up. Creat a new text column and give it a name similar to the one you would like to dupilicate. Then create a WF to auto-populate that column into a text field.