Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Self Referencing Lookups RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Regards

    David Hodgson
    Add me on Twitter and LinkedIn
    www.infinitygroup.co.uk
    Wednesday, November 9, 2011 12:58 PM

Answers

All replies