Lookup Column in a Custom List

A lookup column is a column in a Custom List that will populate itself with values from a column from another list.

e.g., “All Movies” is a list with 5 movies names (in “Title” column).

Now you want to create another list, and specify every your family member’s favoriate movie (movies from “All Movies” list). So create a new costum list call “Family Favorite Movie”. Use the “Title” column to enter family member’s name, and create a new lookup column (Column anme: “Favorite Movie”), and get its value from the “Title” column of the “All Movies” list.


Click OK to create a list. Once done, you can add a new item in “Family Favorite Movie”, and this is what you see – the “Favorite Movie” field is a drop down list, populated from “All Movies”.


 
 

  

Advertisements
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: