AxioWorks Logo

LAB-02: How-To Handle Many-To-Many List Relationships

Assign tags to articles and display a "tag cloud"

In this tutorial we will see how to assign tags to news articles, display a tag cloud and filter articles by the tags associated to them.

Please note the following points that will be covered in this tutorial:

  • How to assign multiple look-up values to a SharePoint list entry;
  • How SQList generates the necessary tables to handle the many-2-many relationship between the "News Articles" and the "Tags" list in a properly normalised way;
  • Assigned tags will follow the same approval process as the articles themselves so that only approved tags are displayed next to an article by the website.

This tutorial will build on top of the lists & tables created in the previous lab; if you have not already done so, we suggest you review LAB-01 first.

As you will remember, in the previous tutorial we created the "News Articles" list in SharePoint and displayed them in the web; here are a couple of screenshots as a reminder:

The "News Articles" list in SharePoint

The "News Articles" table generated by SQList in SQL Server

Continue...

Copyright 2011, AxioWorks Ltd. All rights reserved. | Sitemap | Terms of Use | Privacy Policy