AnsweredAssumed Answered

"If" formula question

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

Title

"If" formula question

Post

    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. 

 

Outcomes