Finding documents their relation with list


  • Hey all,

    We've got a list of documents in Sharepoint of which each document is linked to 0, 1 or more products. If you'll look at the screenshot below you'll understand the scenario. Now for an ASP.NET application we need to give a listing of the documents and the users need to be able to filter on them based on the products.

    In the database I can find the documents and I can also find the products in another list, but I can't seem to find the relations between these 2.

    So for example:
    In the screenshot the selected document is linked to 3 products ( Aastra 5000 ACP, Aastra 5000 TWP 3.2 and Aastra 5000 UCP. I know where the documents are in the database and I know where the product families are, but I can't find those 3 linked product families and then I'm talking about the actual link ( many2many records? ).

    Thanks in advance,
    - Yannick

    Wednesday, April 11, 2012 12:35 PM

All replies