AnsweredAssumed Answered

"If" formula question

Question asked by IgorK on Jul 17, 2009
Latest reply on Jul 17, 2009 by IgorK


"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.