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