Hi folks - first post, really new at all this so please be kind!
I’m trying to build an equipment database for our fire station. We need to be able to assign equipment to a category, then have a list of subcategories based on which category the user selects.
> Mobile Radios
I’ve built an object (table) with the categories and figured out how to connect it to the main table. It generates the categories just fine, but I can’t figure out how to get the subcategories to appear based on the category chosen.
My category table has two fields, the category name and the subcategory name:
It shows multiple iterations of the category in the main table, but doesn’t show the subcategory options:
I’ve tried searching the KB and this forum without success. If the answer to my question is posted elseshere, I’d appreciate pointing me to it. Otherwise, any assistance is more than welcome. I’m a firefighter not an IT professional, so treat me like I’m in 5th grade!