Self Referencing Lookups RRS feed

  • Question

  • Hi All,

    In my quest to build a custom IT Helpdesk I believe I need to use a 'Self Referencing Lookup' (is this also know as an N:N Relationship?)

    Basically my ticket form will follow ITIL Guidlines of Prioritizing and Categorizing. In terms of categorizing I want the following fields

    • Issue Type
    • Sub-Issue Type
    • Skill

    Issue type may be 'Hardware Problems' then sub type could by 'Printer' or 'Mouse' and Skill would be 'Hardware Skills'

    Do I set up an entity called Category then 3 more entities called issue, sub issue and skill then use lookup fields on the category entity to build the categories linking to the other entities?

    How would I add the fields to the ticket form, I would like to be able to pick the 'Issue Type' and then the Sub-Issue and Skill be filtered based on the selection.

    Any help and guidland on this would be greatly appreciated.


    David Hodgson
    Add me on Twitter and LinkedIn
    Wednesday, November 9, 2011 12:58 PM


All replies