Creating a lookup list

- [Instructor] Next, let's talk about two of the options…that we have for creating those columns that provide you…with the drop down list of pre-populated values.…There are two types of columns in SharePoint that allow you…to make selections from a set of options.…Those are the choice column and the lookup column.…A choice column is best used when you have a standard set…of choices that never changes or doesn't change very often.…In this case, we have the event type column,…which is breakfast, lunch, dinner, breakout, and wedding.…The entries in this list do not change very often.…A lookup column is best used when you have a dynamic set…of information that you need to select from.…

As the number of entries grow within the list,…the options in the drop down list are also updated.…In this case, we have our table of leads.…So as new leads are added,…we would want them to appear in the drop down.…Typically, this is one column out of many…in another list or library within your site.…SharePoint gives you the ability to connect one list…