3 Replies Latest reply on Jul 17, 2009 9:58 AM by IgorK

    "If" formula question



      "If" formula question


          I am not sure if it is "if" formula question or relationship or something else. But here is the question:

      I am creating an inventory card. I have Department field and Category field for each item. There are around 8 Departments and around 50 categories total. Each department has several categories. How do I set up a Category field the way that it shows only specific categories for specific department?

          I made a drop down list of my departments, and when I choose one of them I want Category field to show categories for this specific department that I selected. Thank you for your help.