A look at the tables created by SQList in the SQL Server database
You do not need to change your SQList replication profile for the new Tags list to be replicated to the SQL database.
3.1 In the database there are now two new tables: AxioWorksLab02:Tags and AxioWorksLab02:NewsArticles.AssignedTags
The AxioWorksLab02:Tags table is straight forward; it contains all the entries in the Tags list.
The AxioWorksLab02:NewsArticles.AssignedTags is instead the table that allows the many-to-many replationship between the NewArticles and the Tags tables. This table contains a row for each pair of IDs from the NewsArticles and Tags table as they are assigned in the Sharepoint list.
Note that the structure of the table contains only two columns, one for each ID. The column names are prefixed by "Parent" and "Child" to avoid duplicate names in case a Sharepoint list has a multiple-lookup against itself as well as to describe the direction of the relationship
From this point on, SQList will keep the SQL tables synchronized with the Sharepoint list (data and structure). Now we can write some simple code to display a "Tag cloud" on our website.
