Creating the "Tags" list in SharePoint and assigning them to the "News Articles"
Let's start by creating a new SharePoint list where we are going to store all our tags. If you have completed all the steps in Lab-01, you will have by now a copy of SQList running and replicating the SharePoint "News Artciles" list to your SQL database. Also, by now you should be familiar with the steps of creating new lists and columns in a SharePoint site therefore we will not describe these steps in detail.
Important: You do not need to make any changes to the SQList profile; the new list and columns will automatically be recognised by SQList and replicated..
1.1 - Create a new named Tags and fill in some random entries.
There is no need to add any additional columns to the default ones. We will use the Title column to store our tags.
1.2 - Add a new column named AssignedTags to the News Articles list; set the source of the look-up to be the Tags list and allow multiple choices.
This is all is needed to link two lists in SharePoint. In the next step we will see how SQList manages to create all the necessary tables in the SQL database to replicate this many-to-many relationship.
1.3 - Assign the Tags to the News Articles.
Assigning the tags to the articles is a straight forward operation; just edit each entry in the News Articles list and you will be presented with the new AssignedTags column that will allow you select the tags you want to assign to the article.
Let's now take a look at the tables created by SQList in the SQL Server database.
